Phil,SELECT userIDFROM userTableWHERE userName = 'UsErNaMe'AND cast(userName
AS thisUser) = cast('UsErNaMe' AS thisUser)That should do it for youPaul
GiesenhagenQuillDesign----- Original Message -----
From: "Phillip B" <[EMAIL PROTECTED]>
To: "SQL" <[EMAIL PROTECTED]>
Sent: Wednesday, February 26, 2003 3:13 PM
Subject: Case sensitive search> How do you do a case sensitive search in SQL 2000? When I search for "what" it will find "what" and "What". This isn't good when you're writing login code. > > Thanks Phillip B. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
