using ILIKE xyz where xyz is a function parameter

Question posted by: Frank Footon (Guest) on July 10th, 2007 10:55 PM

Hi,

I'm stuck here.

I have a function that I would like to pass a text string and have the
function perform ILIKE on that passed string.

create or replace function foo( sLastName text )
AS

Select * from Person where LastName ILIKE sLastName;
....


What is the syntax for using ILIKE '%sLastName%' ??

Thanks for any tips,

Frank

Not the answer you were looking for? Post your question . . .
189,873 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).