From: "Antti Kurenniemi" <Antti@...>

> Hello again.
>
>
> I have a table with people's names in it, split to firstname and lastname
> fields. How would I go about having the name formatted from the two

separate

> fields to one, as "Kurenniemi, Antti" (that's "lastname, firstname") in a
> IB_LookupCombo - or for that matter, in a grid column?
>

Select (LastName || ', ' || FirstName) as FullName, OtherFields from Names

If there are nulls in the name fields, you may have to use COALESCE to force
them to be included.

Woody (TMW)