extra space in sql where condition issue

Question

I am using SQL Server 2008 r2 and facing a problem while executing a select command. Please look into the structure of my table(all column's datatype is nvarchar) :

employee  id      fname   lname
--------------------------------
abcdef    12345   Amit    Sharma
abcdeg    12346   Amit    Shar

when I try to query out with following command

select * 
from userinfo 
where employee = 'abcdef   ' and id = '12345    '

It still gives me the result back.

I am not able to identify the problem.

Please suggest me anything that I can do to fix this.

"it still gives me the result back" ??what are you exactly expecting?? — Chandru velan, Apr 08 '13 at 08:21
hi chandru thanks for replying...i have edited the post... problem is when i try appending extra space in where condition — Amit Sharma, Apr 08 '13 at 09:13
Hi NetStarter ...these where conditions comes from user input...and if appended extra spaces it should not return any result but still SQLSERVER ignores the extra space and return the result.. — Amit Sharma, Apr 08 '13 at 09:16

score 2 · Accepted Answer · edited May 23 '17 at 12:29

2

You have a valid point but it is according to SQL Standard you can read this link to find out what is the difference in = and LIKE,also following answer on SO from Milan Babuškov Hope it helps

edited May 23 '17 at 12:29

Community

1
1

answered Apr 08 '13 at 09:33

NetStarter

3,189
7
37
48

extra space in sql where condition issue

1 Answers1