Archives of the TeradataForum

Message Posted: Tue, 07 Dec 2004 @ 14:56:20 GMT

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

Jebaseelan_S:

From your description here, I cannot say I understand all the ramifications of what you are attempting to do here. However, I have solve a problem that sounds similar to your efforts. Instead of using an IN, I used the POSITION:

     WHERE POSITION(col1 IN $INPUT) > 0   /* if not found POSITION returns 0 */

This uses the POSITION function like a LIKE without having to worry about the wildcard characters. Of course, you don't have the ability to lock it to a specific location within the string, but it does not sound like that is a requirement for you.

Hope this gives you another option.

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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