Re: How to merge several attributes and Delete an attribute - Mailing list pgsql-sql

On 31 Jan 2002, Christopher Kings-Lynne wrote:

> update table set newcol = FirstName||" "||MiddleName||" "||LastName;
>
> But why do that???  Just do your like query as follows:
>
> select * from table where FirstName like 'blah' or MiddleName like 'blah' or
> LastName like 'blah';

or...

select * from table where FirstName||" "||MiddleName||" "||LastName like
'blah';
-- 
Tod McQuillin