Archives of the TeradataForum

Message Posted: Wed, 07 Mar 2012 @ 13:04:12 GMT

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

Add a Trim to the tablename:

     SELECT * FROM DBC.TABLES WHERE DATABASENAME='MYDB' AND TRIM(TABLENAME) LIKE 'H%WORLD' ;

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