Help: Oracle "select" statement question!!

Hello fellow Oracle people,

I need your assistance.

I am trying to perform the following Oracle statement:

select TO_CHAR(id) from message_data where organization = "org" AND TO_CHAR(id) NOT IN (select seen_urls from smartpage_data);

I am trying to search for an occurence substring "id" in the result of the "select seen_urls from smartpage_data" statement which returns a string. The NOT IN function does not check for occurences of substring. It just checks the entire string.

Is there a function or method I can use to serarch for the occurence of a substring in the result of a select statement?

Thank You

John Dixon Received on Wed Jul 23 1997 - 00:00:00 CDT