Archives of the TeradataForum

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

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

How about this

     Select SUBSTR('CA, SFO 94109-11',1,INDEX('CA, SFO 94109-11',',')-1)

--Prasanna

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