Issue in selecting data from SQL Server 2008

Question

Hi I have a table in my SQL Server. I have copied all the data from an excel to table. When I am querying the data like this.. SELECT [App_Name]  [Link]  [Comments] FROM [App_Links] where Env_Ref_ID = 1 and App_Name = 'O2' I am not getting the result. But I have O2 in my table when queries as SELECT [App_Name]  [Link]  [Comments] FROM [App_Links] where Env_Ref_ID = 1 Issue is Column App_Name has got some space or other special characters it seems. I even tried with this.. SELECT [App_Name]  [Link]  [Comments] FROM [App_Links] where Env_Ref_ID = 1 and LTRIM ( RTRIM ( App_Name )) = 'O2' order by Link but was no use. When I tried to copy cell data it was like this 'O2 '. Any suggestion son this please. Thanks Sreenath

Suthish Nair · Answer

That might helps... also try.. upper(App_Name)

Felipe Ramos · Answer

My two cents is that since App_Name is a reserved key word is actually returning the App_Name() for instance for me it would be 'Microsoft SQL Server Management Studio - Query'. Try And [App_Name] = '02' instead.

Sreenath G · Answer

Hi..I have already tried these..but was of no use.. :(

Suthish Nair · Answer

another way: select * from hello where sno like '%01%'

Muralidharan Deenathayalan · Answer

You have to use rtrim(ltrim(columname)) on the both the sides.

Suthish Nair · Answer

eg: select * from hello where rtrim(ltrim(sno)) = rtrim(ltrim('01'))