Hi,

I tried to follow closely the example to join first_name & last_name
together, but somehow I still got the error.
If I omit the &''& last_name , it then can show first_name correctly.

Thanks for your time & looking forward for your reply,
Adhitya


x.dbDisplayLookupList="(;|)contact_prsn_id||se lect contact_prsn_id, first_name & '' & last_name as Name FROM databasename.contact_person;"

----Error message:---------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid operator for data type. Operator equals boolean AND, type equals varchar.

/editlab.asp, line 150