> 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?
Thank you.