SQL SELECT, DataSet Table Select, and Apostrophes...

[Gladimir]

I pull a string from one table and look for a matching string in another table.

 

In this case, the string I pull from the first table is:

 

G_App_Attorney'sBriefcaseCaliforniaEvidence

 

I strip the first 6 chars from the string (G_App_) and search for the matching string:

 

Attorney'sBriefcaseCaliforniaEvidence

 

If I strip the apostrophe from the first string, then it will not match the second string.

 

How is this situation typically handled?

[rido111]

Replace

 

Hi,

 

If you want to use aposthrope in your sql statement then you have to replace each aposthrope with double aposthropes

 

example

 

string temp = "you've got it!";

temp = temp.Replace("'","''");