From: Lee C. <lee...@ad...> - 2003-07-27 19:59:29
|
Can someone tell me how I can tell my database not to use case sensitive = searches and compares? I have seen an article on doing this but it = involved creating a "cloned field" if you will, and adding the data to = the original field as is and then adding the data using an Upper or = Lower case method into the "cloned field". Then when comparing when not = needing case sensitivity you would do an Upper or Lower on the data = being sent to the database against the "cloned field". Is there a = different way of accomplishing this? Lee |