Replace ' with '' in string

Hello,
I am passing the values to sql which have apostrophe in it.
There are quite a few stored procedures and the lot of parameters is there a better way of chaging the value
from ' to '' in a string or value1.Replace("XX", "Areo") is the only way.

Cheers
RIASAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
KimputerConnect With a Mentor Commented:
Strings.Replace("'1'", """1""")

Open in new window

means in sql it's
'1'
to
"1"
0
 
RIASAuthor Commented:
Cheers
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.