Archives of the TeradataForum

Message Posted: Sat, 13 Mar 2004 @ 09:42:51 GMT

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

Beverly,

I didn't send too much time on this but my first guess is that the trim causes the problem as this will remove the second bank prior to the further evaluation as it is the first char after the substr.

      index (Str_Address,' ') as Index_1,
      (character_length (str_address) - index_1) as rem_add_1,
      index (trim(substr(Str_Address, index_1+1)), ' ') + Index_1 As Index_2,

Ulrich

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