Archives of the TeradataForum

Message Posted: Fri, 08 Dec 2006 @ 10:50:51 GMT

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

Try this .....

     WHERE SUBSTR ( TRIM(DECCOLNAME (VARCHAR(10))), 4 ,1) = '9' ;

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