Subject Re: [IBO] Formatting text in a ComboBox (or grid column)
Author Woody (TMW)
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
> 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)