Someone asked me what would be an easy way to ensure that the value of a user-supplied bind variable value was always in uppercase.so that they could avoid having to worry about putting SQL UPPER() functions in their queries to deliver case-insensitive queries on columns that they already knew would be stored in uppercase in the database. I've posted example#118 with one solution for doing this in a generic way, driven from custom metadata properties on your bind variables.
6:26:08 PM
|
|