>>Microsoft Access is terrible. Well, yet another legendary Access database bashing :-( Access database are GREAT for any small/medium web application.
Most databases implement the string comparison to be case insensitive by default. They also have provisions to change it either globally or locally, and COLLATE is just one of them, not the simplest one. In Access, there is a very simple solution : the StrComp() function In your case, try WHERE strComp(password, '#from.passWord#', 0) = 0 Parameter 0 stands for "binary compare", 1 would be for case insensitve compare ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323487 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
