Need help to Concatenate in a Stored Procedure

• Anthony Phillips-301303

  Mr or Mrs. 500

  Points: 574

  More actions

  May 8, 2006 at 7:24 am

  #169498

  I hope someone can help me with this. I'm trying to do some concatenation in a stored procedure. I have in an Access query this string.

  MyAACol: "AA" & [Org] & "00" & [Acct_Nbr] & [Tran_Code] & [Amount]

  The variables "AA" and "00" are not actual fields in the table but text I want to include in the string. The name of the field wil be MyAACol. How this same thing be accomplished in a stored procedure?  

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  May 8, 2006 at 9:14 am

  #636548

  "+" is the string concatenation operator in T-SQL.  If the table columns aren't character, you'll have to CAST them.

  Greg

  Greg

• Marshall Smith

  SSCrazy

  Points: 2041

  More actions

  May 9, 2006 at 7:18 am

  #636723

  Also, you want to use single quotes instead of double quotes.

  So, assuming Tran_Code and Amount are numeric data types and the others are not:

  ('AA' + [Org] + '00' + [Acct_Nbr] + CAST([Tran_Code] as varchar(10)) + CAST([Amount] as varchar(30)) ) AS MyAACol

• kevin mann

  Hall of Fame

  Points: 3894

  More actions

  May 9, 2006 at 7:56 am

  #636746

  and null ''

  null + 'any string' = null

  you will have to use the ISNULL() function which is simillar to the NZ() function in ACCESS.

  ISNULL(null,'') + 'any string' = 'any string'