J
|
Jane 4/11/2008 |
Hi, select a + ' ' + b + ' ' + c + ' ' + d as [abcd], fieldname1, fieldname2, ... from TableName |
P
|
paulyap2k 5/6/2008 |
if there is a pontential null value in any of the fields to be combined, I have tried this to avoid new field becoming a null value. |