I have a Java App which I have a connection to a SQL server to. The problem is that when i Excecute a Update/Insert statement and the content contains a ' the Update fails because i already got this In my Code.
Void Update(String SQL)
//Class connction goes here..
Update dbo.Table set Column ='" + SQL + '");
Then if the SQL Variable already contains a ' then it will Fail.. Is there any way i can get around this problem?