Archives of the TeradataForum

Message Posted: Mon, 19 Sep 2005 @ 22:03:52 GMT

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

     Select *
     from tb_test
     where upper(substring(col1 from 1 for 1))(casespecific) <>
     lower(substring(col1 from 1 for 1))(casespecific);

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