Calculated Fields in SP

J

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.
 
B

BJ Freeman

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
Combobox 2
Need some PWA help 0
Append Crosstab Query to Existing Table 0
Insert Multiple Fields without Dialog closing between each... 0
Start a mail merge upon opening the document 1
Template with fields and premade texts.. 0
Add additional information to excel form after original data entry 0

Top