Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Exir
Posting Yak Master
151 Posts |
 Posted - 2013-05-03 : 03:29:47
|
| What is wrong with this query ?select ID from customer WHERE (Family+' '+Name)= 'smith john'it shows empty column while the opposit query works properly!SELECT (Family+' '+Name) FROM Customer where ID=8it shows "Smith John" as answer |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2013-05-03 : 03:33:02
|
case sensitiv?
Too old to Rock'n'Roll too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-03 : 04:17:49
|
| check the collation and confirm whether its case sensitive or not as Fred suggested------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Exir
Posting Yak Master
151 Posts |
Posted - 2013-05-03 : 05:12:51
|
| No it is not case sensitive |
|
|
|
Exir
Posting Yak Master
151 Posts |
Posted - 2013-05-03 : 05:16:59
|
| Thanks for your answering , i got the problem . It has problem with my language because i use non english language for names |
|
|
|
|
|
|
Help me with this query