Hi
I would like to update a query with special characters like '
the update statement looks loke "update Task set titles = '" & titles & " ' where....."
The problem is if I am using
is save in the database twice of the ' characters for example I the titles= "isn't" it will save it as "isn''t"
How can I save it as "isn't"
Tthanks
I would like to update a query with special characters like '
the update statement looks loke "update Task set titles = '" & titles & " ' where....."
The problem is if I am using
Code:
"update Task set titles = '" & replace (titles,"'","''") & " ' where....."
How can I save it as "isn't"
Tthanks