Archives of the TeradataForum

Message Posted: Wed, 29 Jun 2005 @ 16:13:04 GMT

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

Ruth Alexander wrote:

Victor already told you about the reason, there're som rows with no comma.

     select
        trim(substring(address_Z from 1 for position(',' in address_Z) - 1))
     from sp.tl_116870_v4
     where
        position(',' in address_Z) > 0;

Or using a case until you find the exceptional record and add another case :-)

Dieter

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