Hahaha
You are the one that got me on the right track. The funny thing is this was
to help Matt Sievert.
Phillip B
----- Original Message -----
From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
To: "SQL" <[EMAIL PROTECTED]>
Sent: Wednesday, February 26, 2003 4:04 PM
Subject: Re: Case sensitive search
> Phillip,
>
> Actually you are correct ... just don't call me dumb :)
>
> Paul Giesenhagen
> QuillDesign
>
> ----- Original Message -----
> From: "Phillip B" <[EMAIL PROTECTED]>
> To: "SQL" <[EMAIL PROTECTED]>
> Sent: Wednesday, February 26, 2003 3:58 PM
> Subject: Re: Case sensitive search
>
>
> > Paul,
> >
> > I guess what I ment was that when you use the cast function it needs to
> look
> > something like this. At least that is my understanding.
> >
> > SELECT userID
> > FROM userTable
> > WHERE userName = 'UsErNaMe'
> > AND cast(userName AS varbinary) = cast('UsErNaMe' AS varbinary)
> >
> > ----- Original Message -----
> > From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
> > To: "SQL" <[EMAIL PROTECTED]>
> > Sent: Wednesday, February 26, 2003 3:51 PM
> > Subject: Re: Case sensitive search
> >
> >
> > > Phillip,
> > >
> > > No it is a variable ... (alias) ... like SELECT COUNT(columnName) AS
> > > thisCount
> > >
> > > Paul Giesenhagen
> > > QuillDesign
> > >
> > > ----- Original Message -----
> > > From: "Phillip B" <[EMAIL PROTECTED]>
> > > To: "SQL" <[EMAIL PROTECTED]>
> > > Sent: Wednesday, February 26, 2003 3:46 PM
> > > Subject: Re: Case sensitive search
> > >
> > >
> > > > Is thisUser a userdefined datatype? My thought was that you had to
> > specify
> > > a
> > > > datatype after the as.
> > > >
> > > > Phillip B.
> > > >
> > > > ----- Original Message -----
> > > > From: "Paul Giesenhagen" <[EMAIL PROTECTED]>
> > > > To: "SQL" <[EMAIL PROTECTED]>
> > > > Sent: Wednesday, February 26, 2003 3:29 PM
> > > > Subject: Re: Case sensitive search
> > > >
> > > >
> > > > > 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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
