using ILIKE xyz where xyz is a function parameter

Frank Footon

Guest

Posts: n/a

#1: Jul 10 '07

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

« previous question | next question »

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,418 network members.

using ILIKE xyz where xyz is a function parameter

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

/bytes/about