Archives of the TeradataForum

Message Posted: Tue, 19 Oct 2004 @ 16:41:10 GMT

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

Hi..

I have data values which has _ character..

ex: Person_1, Person_2, Man_Test

I want to do a search using 'like' keyword but since Teradata uses _ keyword ..It gives me errorneous results ..

ex: Select column from Table where fieldname like '%_%'

How do I fix this ????

Thanks..

Subu Sangameswar

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