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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
