Archives of the TeradataForum

Message Posted: Fri, 26 Jun 2009 @ 19:01:02 GMT

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

If you are confident in your data being in the format of number followed by street, you could do the following:

     substring(street_address from 1 for position(' ' in street address)-1)

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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