Issue in selecting data from SQL Server 2008

Question

0.00/5 (No votes)

See more:

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..

SQL

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

SQL

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..

SQL

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

Posted 19-May-11 0:47am

Updated 19-May-11 0:51am

v2

3 solutions

Add a Solution

Treat my content as plain text, not as HTML

…

Sign in to your account

Download, Vote, Comment, Publish.

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Costica U · Answer 1 · 2011-05-19T00:55:00

Update your table with all unwanted characters replaced/removed.

Posted 19-May-11 0:55am

**R. Giskard Reventlov** · Answer 2 · 2011-05-19T00:56:00

It looks like you are querying on '02' but the data is 'O2'. In other words you are looking for zero-two but it contains the letter O plus the two.

Posted 19-May-11 0:56am

Comments

Sreenath Gv 19-May-11 6:57am

No..its O2 only....it is wroking with like token...

Liju Sankar · Answer 3 · 2011-05-30T23:29:00

Data clean up will the best option to improve your maintainability index. else please try by using LIKE keyword instead of =

Posted 30-May-11 23:29pm