I am having trouble removing trailing spaces in a table column (query phrase).
so far i have tried using Ltrim , rtrim but no luck , i have used len and substring as well . funny thing is when using len(queryphrase) its counting the trailing space.
also an update with replace dosen't work
I have set the table with ansi padding off and have used both nvarchar and char columns to see if it made any difference , but no luck there either.
Are there any other options available ???
Thanks in advance