Issue in selecting data from SQL Server 2008

Sreenath G

15y2.3k

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
That might helps... also try.. upper(App_Name)
0
Felipe Ramos15y ago
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.
0
Sreenath G15y ago
Hi..I have already tried these..but was of no use.. :(
0
Suthish Nair15y ago
another way: select * from hello where sno like '%01%'
0
15y ago
You have to use rtrim(ltrim(columname)) on the both the sides.
0
Suthish Nair15y ago
eg: select * from hello where rtrim(ltrim(sno)) = rtrim(ltrim('01'))
0