Concatenating List boxes

[AndyApp]

Can anyone tell me if it is possible to Concatenate a first name field and surname field from a DTC Recordset on a page into a drop down list box? "Life is like a Ferrari, it goes to fast.
But that's ok, because you can't afford it anyway" - Jim Davis (Garfield)

 

[MerlinB]

Yup. Try doing the concatenation in the SQL:

SELECT id, firstname || ' ' || lastname as fullname
FROM...

http://www.websitedesign.co.uk

http://www.zentext.com

(Content Management)