• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 394
  • Last Modified:

Appending singe quotes both sides to a varchar data type

i have varchar datatype variable
lets say  abc
how to convert  abc as 'abc' with some operations(arithmatic or any)
0
pavanark
Asked:
pavanark
1 Solution
 
GO-87Commented:
Would this work?
SELECT '''' & fieldname & ''''
FROM tablename
or alternatively
SELECT CONCAT('''',fieldname,'''')
  FROM tablename  
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now