Archives of the TeradataForum

Message Posted: Fri, 09 Feb 2007 @ 19:15:54 GMT

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

What about building an associative table with a row for each possible derivation and pointing them to a common value and doing a join to it?

Example rows:

     r?sum?,resume
     resume,resume
     res'me,resume
     res'me',resume

Just a thought,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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