Archives of the TeradataForum

Message Posted: Tue, 28 Jun 2005 @ 17:51:29 GMT

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

Use the position function, in the Teradata SQL Reference (at least the one that I have for TTU 7.1)

     select position(',' in column_name) from table_name

Utilize this with the substring function to seperate out whatever you need to. Take care that you have well-formed data as a comma in the city, state, or zip would have bad results. This shouldn't occur in normal circumstances, but if it's user-entered data you never can tell...

Mike

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