Well, I am not familiar with functions, Do they have better performance than
the plain query as the following?
select * from table where Firstname like 'blah' or middlename like
'blah'....
Thank you
Annie
>From: Vladimir Terziev <vladimirt@rila.bg>
>To: "Yan Bai" <annie_job@hotmail.com>
>Subject: Re: [SQL] How to merge several attributes and Delete an attribute
>Date: Thu, 31 Jan 2002 10:21:31 +0200
>
> Hi,
> I sugest you to use 'textcat' function. Something like this:
> select textcat(textcat(textcat(textcat($1, " "), $2), " "), $3)
> ' language 'SQL';
>
> select * from your_table where textcat(textcat(textcat(textcat(FirstName,
>' '), MiddleName), ' '), LastName) like '%somename%';
>
> Good luck!
>
> Vladimir
>
>
>On Thu, 31 Jan 2002 07:34:40 +0000
>"Yan Bai" <annie_job@hotmail.com> wrote:
>
> > Hello all,
> >
> > My initial table has 3 attributes: FirstName, MiddleName and LastName.
>Now I
> > want to merge them into one, then I could make a search action using
>LIKE
> > more easily.
> > what should i do for that?
> >
> > Also, I want to know how to delete one attribute from a table.
> >
> > Thanks a lot,
> >
> > Annie
> >
> > _________________________________________________________________
> > MSN Photos is the easiest way to share and print your photos:
> > http://photos.msn.com/support/worldwide.aspx
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo@postgresql.org so that your
> > message can get through to the mailing list cleanly
_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com