Viewing post 1 (of 1 total)
Thanks for the post - had trouble finding trailing spaces on an nchar field.
SELECT count(Address5)
FROM dbo.Location
WHERE DATALENGTH(Address5)-LEN(Address5) > 2
October 29, 2008 at 12:25 pm
#891416