Archives of the TeradataForum

Message Posted: Fri, 11 Dec 2009 @ 19:58:36 GMT

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

Your Where statement in the SQL probably look like below:

     WHERE NAME LIKE ANY ('%KHAN%', '%JOHN%');

If that is the case, try to build the statement dynamically some thing like this:

     Set Statement_ST = ...... "From Table
     WHERE NAME   LIKE ANY ('% " ||'   '|| :Input_Name.... bla bla

I think you got the idea.... :)

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