Archives of the TeradataForum

Message Posted: Wed, 28 May 2008 @ 15:26:40 GMT

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

Given that a column named string is your text input than the correct substr expression is

     sel
     substr(string,(position('(' in string) + 1),(position('mil' in string) -
     ( position('(' in string) +1)    )        )
     from adhoc.tdf
     ;

Hope this helps.

Tony

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