Subject Re: [IBO] Formatting text in a ComboBox (or grid column)
Author Dennis McFall
Antti Kurenniemi wrote:

>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?
>
>
>
>
The SQL property of the TIB_Query component:

SELECT ..... T1.LASTNAME || ', ' || T1.FIRSTNAME FULLNAME ..... FROM
TABLEONE T1 .....
Then use the computed field name "Fullname" for the various
FieldDisplayLable values etc.

Dennis McFall