In my table there is a row which contains data imported from a file. In tha table in a column after the name extra unwanted space also accidently included.
The problem is while executing the query having WHERE condition i am not geting the result.
For eg Select name from [table] where name = 'name' since name has many spaces trailing it will not give the result . To get the result i have to insert correct extra spaces .
In .NET on using Trim function in the executereader this is not working.
Any good solution please reply as soon as possible.
Thanks and Regards