Concatenating fields in a query

[Wes Peters]

Is it possible to concatenate two text fields into one in a query?

I'm trying to combine FirstName and LastName AS EmpName and have it be the
rowsource in a combo box. I know how to do this in an mdb but not an adp.
It doesn't seem to work the same and I can't find anything on it.

Any thoughts?
Thanks,
Wes

 

[Cinzia]

Is it possible to concatenate two text fields into one in a query?

I'm trying to combine FirstName and LastName AS EmpName and have it be the
rowsource in a combo box. I know how to do this in an mdb but not an adp.
It doesn't seem to work the same and I can't find anything on it.

Any thoughts?
Thanks,
Wes

Hi Wes,
try
SELECT IDEmploye, FirstName + ' ' + LastName as EmpName FROM EMPLOYEES

Bye
Cinzia

 

[Wes Peters]

That works. Looks like it was just a change in the concat operator.

Thanks!

 

[Simon Shaw]

You may find there is more to this if either first or last names might be
null.

I use :
isnull ( firstname + ' ', '' ) + isnull ( lastname , '' )

Rgds
S