That didn't show up correctly! Try this!
Phil,
SELECT userID
FROM userTable
WHERE userName = 'UsErNaMe'
AND cast(userName AS thisUser) = cast('UsErNaMe' AS thisUser)
That should do it for you
Paul Giesenhagen
QuillDesign
----- Original Message -----
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "SQL" <[EMAIL PROTECTED]>
Sent: Wednesday, February 26, 2003 3:26 PM
Subject: Re: Case sensitive search
> 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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
