Archives of the TeradataForum

Message Posted: Wed, 24 Jun 2009 @ 15:45:50 GMT


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

Example: If I have an address of "123 Main Street". How can I return 123?

You could write a UDF that leverages the isnumeric() and/or isalpha() c functions.

The Oracle UDF library available for download from Teradata may already include a similar UDF.


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

Archives

2009 Indexes

Last Modified: 15 Jun 2023