Replace a double quote with a single quote in a string. 1

[steve1rm]

Hello,

I have some strings which I want to replace them with single quotes so that I can use them as arguments that are passed to a sql query.

Example, string variable Name:
"Peter John"

Should be replaced with single quotes
'Peter John'

so name should contain only 'Peter John'

Is there any possible way to do this.

Many thanks,

Steve

 

[majkinetor]

String.Replace

 

[JurkMonkey]

String.Replace but use "\"" and "'" as your search and replace strings.