Archives of the TeradataForum

Message Posted: Tue, 11 Jan 2011 @ 12:31:04 GMT

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

Hi,

You can handle more than one char thru this method Special chars at the end of the string will cause problem,Handle those through a like any sub query.

Table vt1 values

     000000$$
     asdasdapppp
     6789
     123435
     &&1234
     %@$000000
     000000&&
     asdasdasfdasfdasd
     asdasda1234


     sel  *  from vt1
     where columnname between '0' and '9'

ans:

     000000$$
     6789
     123435
     000000&&

Thanks & Regards,

Minakshi Swami
Teradata Consultant

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