Not a Member Yet,
Click here to Register
How do you like the new design?

ID: 446
Viewed: 2978
Added: Aug 19, 2002
Snippet uploaded by: snippet
Written By: Clint LaFever
Demo: Sorry, no demo

User Rated at: 0 Stars
Rate This:

Thank you for your vote. Please wait...

It appears you already voted for this snippet

It appears your vote value was empty

Replaces all single quotes with ` instead.

Highlight all by clicking in box

Highlight All
' Author: Clint LaFever []
' Purpose: Used to replace Single Quotes in a string to ` instead.
' Parameters: pstr=String with single quotes.
' Returns: String without single quotes
Public Function ReplaceSQuotes(pstr As String) As String
On Error Resume Next
Dim spos As Integer
spos = InStr(pstr, "'")
While spos <> 0
pstr = Left(pstr, spos - 1) & "`" & Right(pstr, Len(pstr) - spos)
spos = InStr(pstr, "'")
ReplaceSQuotes = pstr
End Function ;

No Comments to show

Please completely fill out the form below if you want to review this snippet. All reviews are subject to validation.

Replying to a Comment...

Adding your comment. Please wait...

Thanks for adding your comment!. After further review it will be added.

There was a problem adding your comment. Please try again.

Please complete all the fields in the form before sending.

© 2002 - 2017 All Rights Reserved. Conditions