Using '' and & When updating T-SQL table Query correctly

Question

I am having trouble finding the correct syntax for updating this T-SQL table.

Here is my query which is adding an additional ' at the beginning and end.

Query:

  Update [denodo].[dbo].[wrappers]
  SET wrapperWhereClause = '''
  AND County_Input = ''Cheyenne & Arapaho Tribal Court'' 
  AND WrapperID = 729'''
  WHERE wrapperID = '729'

The Outcome here is:

'AND County_Input = 'Cheyenne & Arapaho Tribal Court' AND WrapperID = 729'

The Outcome I am hoping for:

AND County_Input = 'Cheyenne & Arapaho Tribal Court' AND WrapperID = 729

Can anyone help me edit this so I can receive the outcome I am hoping for?

score 2 · Answer 1 · answered Apr 27 '15 at 19:29

2

Try this:

UPDATE [denodo].[dbo].[wrappers] 
SET wrapperWhereClause = 'AND County_Input=''Cheyenne & Arapaho Tribal Court'' AND WrapperID=729' 
WHERE wrapperID = '729'

answered Apr 27 '15 at 19:29

score 0 · Answer 2 · edited Apr 27 '15 at 20:25

0

Try this:

UPDATE [denodo].[dbo].[wrappers]
SET wrapperWhereClause = 'AND County_Input=''Cheyenne & Arapaho Tribal Court'' AND WrapperID=729'
WHERE wrapperID = '729

edited Apr 27 '15 at 20:25

marc_s

732,580
175
1,330
1,459

answered Apr 27 '15 at 19:26

connorsingerline

21
4

I post this on the microsoft forum and received the answer. – connorsingerline Apr 27 '15 at 19:27

Using '' and & When updating T-SQL table Query correctly

2 Answers2