Connecting Tech Pros Worldwide Help | Site Map

using ILIKE xyz where xyz is a function parameter

  #1  
Old July 10th, 2007, 11:55 PM
Frank Footon
Guest
 
Posts: n/a
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


Closed Thread