>> 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.

Thanks Woody, that's exactly the ticket :-)


Antti Kurenniemi