SQL query Very urgent

[aph]

Hi,
we have more than 3000 vendors stored in a table 'VENDOR', the name of the column 'VENDOR_NAME' width 80. I need to find the vendor who is containing maximum # of charecters.

Please advise by writing query.

Thanks
aph.

[Shestakov]

select vendor_name, max(lenght(vendor_name)) from vendor;

[aph]

Thanks for the soloution