Archives of the TeradataForum

Message Posted: Tue, 01 Apr 2003 @ 17:19:47 GMT

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

You place an escape character immediately in front of the literal underscore and then define it using the keyword ESCAPE. Teradata will then know that you are looking for the underscore, not for a wildcard. Try the following syntax to find data ending in "_A" using ESCAPE:

Select *
from A
where A1 like ('%\_A') ESCAPE '\';

I hope this helps!

-Morgan

Morgan Jones, Teradata Certified Master
Coffing Data Warehousing
Columbia SC Office

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