RE: Uppercase conversion
There is a way to do searched without case sensitivity. It can be done
with some code, but not pure SQL. If you separate all the characters in
the string you are searching for, and then determine their upper and
lower case equivalents, you can then plug these into an SQL. Here is an
example:
Search for "SILVER"
SELECT l_name FROM cust WHERE l_name MATCHES '[Ss][Ii][Ll][Vv][Ee][Rr]'
This may be much slower than a normal search, but will return the proper
rows.
...Michael...
}-----Original Message-----
}From: hartleh1@westat.com [SMTP:hartleh1@westat.com]
}Sent: Wednesday, April 02, 1997 9:29 AM
}To: informix-list@rmy.emory.edu
}Subject: Re: Uppercase conversion
}
}On Thu, 13 Mar 1997 16:25:38 GMT, albertob@flash.net wrote:
}
}>Hi,
}>I am new to Informix. Does anyone knows how to convert a field to
}>Uppercase or to make a query condition not case sensitive?
}>
}>Thanks
}>Alberto
}
}Based upon the responses to this question, doing a true,
}non-case-sensitive search is not possible in Informix. Will this be
}true of Oracle and Sybase also?
}
}Currently, the two small databases I have been asked to build in
}Informix were all in upper case but the next one may not be.
}
}Henry