I am currently trying to replace single quotes with double quotes to insert into a Database. However it ignores the following
sString = "O'Brien"
sString.Replace("'","''")
Even if i use convert.tochar method it doesn't recognise ' in the string.
Any one any ideas?