Archives of the TeradataForum

Message Posted: Tue, 05 Feb 2014 @ 00:03:13 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Usually oracle convert everything to lower case (or upper case) to do case insensitive comparisons.

You could do the same. For example:

     SELECT OREPLACE  ('mon Tue Wed' , 'MON' , 'Mon') Might become:
     SELECT OREPLACE  (upper('mon Tue Wed') , 'MON' , 'Mon')

Or if necessary

     SELECT OREPLACE  (upper('mon Tue Wed') , upper('MON') , 'Mon')

Obviously he use of upper *in this example* is unnecessary because string literals are being used. However, if the original string, or the search string are column references, then use of upper is a viable option.

Glenn Mc

	<Prev	Next>		<<First	<Prev	Next>	Last>>