Archives of the TeradataForum

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

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

View dbc.tables converts column tvm.TVMName to type char(30). You can use condition trim(tablename) like '%WORLD' or tablename like '%WORLD%'

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