HELP: Clever SQL Needed

Hi,

I'm trying to create a trigger that detects a query for a specific column on a table like this:

    select * from <table> where <column1> = '<value>' and <column2> = '<value>'

and changes it into something like this:

    select * from <table> where <column1> like '%<value>%' and <column2> = '<value>'

Essentially, I'm trying to workaround the limitations of a 3rd party tool.

Please help.

Chris

--
Chris Forlano
TMS Project Manager
Nortel Networks, Maidenhead
590 4342 (01628 434 342)
cforlano_at_nortelnetworks.com Received on Thu Sep 02 1999 - 10:55:55 CDT