SQL column length query
- by Mike
i've been using the following query:
select LEN(columnname) as columnmame
from dbo.amu_datastaging
This works, but is there a way to only return the greatest value instead of all the values?
So if i return 1million records and the longest length is 400, the query would just return the value of 400?