How to customize inserted hyperlinks? Part 2

I have inserted RTE to a small content management system that we operate which has never allowed double quotes to be included. I've tried using the ASP replace command to no avail and so my next step is to try and amend links so that they read

<a href='www.google.com'>Google</a> rather than <a href="www.google.com">Google</a>.

Where is the code that I need to edit? Also, I've noticed tat when I try and amend the code manually, when I come to redit the page, double quotes are loaded back in causing problems to re-occur.

Please help!!!

I'm fairly new to ASP (having used PHP a bit before) but using double quotes tends to mess up submissions to the SQL database. I've a feeling it's becasue of the way the string  to submit to the database works...

        SQLstmt = "UPDATE Messages Set Title = '"& title & "',"
       SQLstmt = SQLstmt & "Description='" & fixQuotes(desc) & "',"
        SQLstmt = SQLstmt & "body='" & body & "',"
        SQLstmt = SQLstmt & "startdate='" & MediumDate(Startdate) & "',"
        SQLstmt = SQLstmt & "enddate='" & MediumDate(Enddate) & "',"
        SQLstmt = SQLstmt & "alert='" & Alert & "' "        
        SQLstmt = SQLstmt & "WHERE ID='" & request.form("ID") & "'"
         Set RS = objConn.execute(SQLstmt)  

but I may be wrong. Anyway, I have used ASP replace function to allow apotrophe's, change cats to dogs, boys to girls but I can't get it to handle double quotes. Historically, users had been told not to use them, but having included a nice Text editor, I'm now told that they want to include active links in text but it's driving me batty at the moment.

Ideally I'd have had the time to rewrite the whole system to something much less restrictive but it was the normal tale of needing something quickly...and then then changing requiremnts!

I am currently using Firefox 1.5 (because it's ruddy great!)!

Thanks for you reply.

The function to replace the single quotes is working fine, it's just with the double quotes that things go a big wrong for some reason. I've tried various things and currently have it set up as so,

function fixQuotes(strData)
    fixQuotes=Replace(strData,chr(39),chr(39) & chr(39))   
    fixQuotes=Replace(fixQuotes,"dog","cat")
    fixQuotes=Replace(fixQuotes,chr(34),chr(34) & chr(34))
    fixQuotes=Replace(fixQuotes,"""", "\""", 1, -1, 1)
    fixQuotes=replace(fixQuotes, chr(34), "&rdquo;")   
    fixQuotes=Replace(fixQuotes,"boy", "girl")               
end function

as you can see, I'm trying pretty much everything at the moment but as soon as a double quote is used it obvioulsy closes the string as only submits preceeding text to the database which is why I'm having difficulties with the link functionality.

For some reason, each entry to the SQL database closes when double quotes appear, even after the string variable has been run through the fixQuotes function that corrects and amends everything else.

As far as I know the way in which I've built the SQL statement isn't an issue, and the corrective script is working correctly  in respect of everything else  but replacing the double quotes.

Is there nowhere within the RTE that would allow me to edit the anchor link?