Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Apostrophe check
Message
From
28/01/2003 14:57:39
Jason Dalio
Northern Interior Regional Health Board
Prince George, British Columbia, Canada
 
 
To
28/01/2003 14:50:46
Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada
General information
Forum:
Visual Basic
Category:
Coding, syntax & commands
Title:
Re: Apostrophe check
Miscellaneous
Thread ID:
00746206
Message ID:
00746389
Views:
26
This message has been marked as the solution to the initial question of the thread.
You are overwriting the first set of results with the second. Try it this way instead (or use another temorary string if you want to keep strCheckString intact):

strCheckString = Replace(strCheckString, Chr(39), Chr(39) & Chr(39))
SQLApostropheCheck = Replace(strCheckString, "&", "&&")
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform