Solved

Replace ' with '' in string

Posted on 2016-09-21
2
34 Views
Last Modified: 2016-09-21
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
0
Comment
Question by:RIAS
2 Comments
 
LVL 35

Accepted Solution

by:
Kimputer earned 500 total points
ID: 41808568
Strings.Replace("'1'", """1""")

Open in new window

means in sql it's
'1'
to
"1"
0
 

Author Closing Comment

by:RIAS
ID: 41808587
Cheers
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question