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.html 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
