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