True, I did specify it was the easiest answer ;-) At 03:34 PM 2/26/2003 -0600, you wrote: >The only problem with that is you limit the combinations of characters ... >though 26 is alot for sure, but 52 is even better. All that it takes is >alittle SQL > >Paul Giesenhagen >QuillDesign > > > >----- Original Message ----- >From: "Mary Jackson" <[EMAIL PROTECTED]> >To: "SQL" <[EMAIL PROTECTED]> >Sent: Wednesday, February 26, 2003 3:26 PM >Subject: Re: Case sensitive search > > > > Easiest answer: > > Don't let the user choose the case. If they choose their own login and > > password, change it to the case you want. Then when you check the >database > > search with the case you choose. > > > > Else, check out the following: > > >http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_10024036.ht >ml > > > > At 03:13 PM 2/26/2003 -0600, you wrote: > > >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
