Trigger and LIKE SQL syntax

[Vic Sithasanan]

Hi there,

I would like to run an SQL statement within a trigger that has a LIKE statement. The only problem is I want to be able to do this:

select count(name) into old_name_count from store where name LIKE ('%NEW.name%');

I'm not able to do this in any form, i.e I can't get the % to bracket the NEW.name trigger variable. I can run this command:

select count(name) into old_name_count from store where name LIKE (NEW.name);

But can't figure out the syntax to run %NEW.name% so I can match any entry that contains this string.

Cheers.



Edited 2 time(s). Last edit at 11/08/2005 03:11AM by Vic Sithasanan.