Dear All,
There is a table
ID Name
---- -----
1 Peter
2 Mary
3 PauL

I would like to get all these three records and return in a single field, that is,

PeterMaryPaul

Is it possible to do with SQL in Access2000?

Thanks.