Formats string containing apostrophes so it can be used by SQL
by Alain Craven (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Wed 2nd July 2003
Date Added: Mon 8th February 2021
Rating: (1 Votes)
Formats string containing apostrophes so it can be used by SQL
Rate Formats string containing apostrophes so it can be used by SQL
Dim tmp$
tmp = strString
tmp = Replace(tmp, "'", "''")
UnQuote = tmp
End Function
Download this snippet
Add to My Saved Code
Formats string containing apostrophes so it can be used by SQL Comments
No comments have been posted about Formats string containing apostrophes so it can be used by SQL. Why not be the first to post a comment about Formats string containing apostrophes so it can be used by SQL.
Post your comment