Alter a String in a VB program for use in an SQL statement
Version Compatibility: Visual Basic 6, Visual Basic.NET
The replace method, which is only available in VB6 or higher is used here. If you want to do the same thing in an earlier version, check out This code sample which provide a version of the replace function for VB5.
Instructions: Copy the declarations and code below and paste directly into your VB project.