Archives of the TeradataForum

Message Posted: Mon, 15 Sep 2003 @ 15:19:09 GMT

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

I find it easy to search for special characters via CHAR2HEXINT, so...

Select * from customer_table where position('27' in CHAR2HEXINT(cust_name))>0

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