Calculated Fields in SP

[Justin]

I'm trying to create a SP (append) with claculated
fields. I need to combine fields and string constants.
What is the correct syntax.

 

[BJ Freeman]

varchars are + to concatenate
then you can use coalesce, convert, cast to marry numeric with varchars.