Trailing Spaces = Trailing Nothings
Posted on 2008-10-21
I have a two rows of data in which one of the columns has the following data :
'1234567 ' (Seven trailing spaces)
When I run a query against the Column_name = '1234567', it returns both of the rows - SHould it?
When I run a query against the Column_name like '1234567 %', it returns the rows with trailing spaces - Which makes sense.
When I run a query against the LEN(Column_name) - it both returns '7' which I am assuming LEN function does not count the trailing spaces - please confirm.