|Subject||Re: [IBO] Formatting text in a ComboBox (or grid column)|
>> I have a table with people's names in it, split to firstname and lastnameThanks Woody, that's exactly the ticket :-)
>> fields. How would I go about having the name formatted from the two
>> 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
> If there are nulls in the name fields, you may have to use COALESCE to
> them to be included.