|
-
Oct 11th, 2001, 08:21 PM
#1
Thread Starter
Fanatic Member
case sensitive in MS SQL
I have a table (USERINFO) in MSSQL database with 2 columns: USR, PWD
Let say I have 1 record: ABC, ****
Now when I perform these:
Select * from USERINFO where USR = "ABC"
Select * from USERINFO where USR = "aBc"
.....
I always get 1 record. How do I compare the string case sensitive so that only
Select * from USERINFO where USR = "ABC"
will return 1 record.
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|