The string concatination below works in the Query builder built-in to MS Access, but when I try it as an OleDbCommand it doesn't work.



SELECT ID, LastName + ', ' + FirstName AS Names FROM AgentNames;




Is there any other ways to return a combination like this using an OleDbCommand?

Thanks,

Grier

Shot in the dark here but try [LastName + ',' + FirstName] as Names. If not, I dont know why that won't work.