Archives of the TeradataForum

Message Posted: Tue, 20 Feb 2007 @ 10:35:38 GMT

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

Rajesh,

I think we could if we knew the position (Last string of Address Value). We may also extract 6 continues character that appear as Numbers in Address3. This may not work if there are other 6 continues characters in the address field.

Use POSITION and SUBSTRING functions.

Thanks,

Vinay Bagare
Technical Manager
Amp'd Mobile Inc
www.ampd.com

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