>I am trying to write '56230','62214' to a character field in a db2 table. I have tried every syntax combo I can think of including the following but nothing works. I need help.
>
>

>
>bl = "'56230','62217'"
>testString = "Update webprddt7.resmngta7 Set attribval = '" + bl + "' Where attribname = 'HeadCou
>
>

Try to double the quote, e.g.

bl = strtran(bl,['],[''])

testString = "Update webprddt7.resmngta7 Set attribval = '" + bl + "' Where attribname = 'HeadCountBadgeExclusions'

Also, if possible, use parameters instead of string concatenation to avoid this problem, e.g.

bl = "'56230','62217'"

testString = "Update webprddt7.resmngta7 Set attribval =?m.bl  Where attribname = 'HeadCountBadgeExclusions'