Script Problem

[#1]

I am getting data in the table but I am getting no data in the new DeputyName field.  Here is an abstract of the script.  Any help would be greatly appreciated.  Thanks.

DeputyTable:

LOAD DT_DeputyFName,
DT_DeputyLName,
rtrim(DT_DeputyLName) + ', ' + rtrim(DT_DeputyFName) as DeputyName,
DT_DeputyNum as DeputyNum,
DT_Inactive;
SQL SELECT DT_DeputyFName,
DT_DeputyLName,
DT_DeputyNum,
DT_Inactive
FROM dbo.DeputyTable;

[spsrk_84 · Accepted solution]

Hi,

rtrim(DT_DeputyLName) + ', ' + rtrim(DT_DeputyFName) as DeputyName,
Chnage this statement to

rtrim(DT_DeputyLName) &', ' & rtrim(DT_DeputyFName) as DeputyName,

hope this works..

Thanks,

Shivaram