You would do something like this...
select CustomerLastName + isnull(', '+CustomerFirstName,'')
RAC v2.2 & QALite!
"Christopher Dean" <hk4achotmail.com> wrote in message
> I am new to SQL in stored procedures and want to accomplish the
> Pull [CustomerLastName] AND If [CustomerFirstName] is NOT null, then
> insert "," and [CustomerFirstName]. Otherwise, insert " ".
> I have tried to accomplish this with the following code but get an
> error when trying to save this as a stored procedure in an Access
> Project linked to a SQL database.