Replace characters in String

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi,

I'm trying to replace special characters in a string before inserting into a database, but cannot this to work, could some please help.

sMyString = "blah, blah blah's +"

with sMyString
.Replace(sMyString, "+", "and")
.Replace(sMyString, "&", "and")
end with



.

Relevant Pages

  • Re: return multiple rows from sql statement
    ... strings from input values is almost certainly a safe path to SQL ... All characters that are entered in the fields make their way into the database unaltered. ... Also, mysql_real_escape_stringwill take care of NOT altering data when inserting it, providing you don;t have any hidious mechanisms like magic quotes enabled. ... The insert of what surprisinlgly was NOT a syntax error, but a string called "mysql_insert_id" into an integer field resulted in the value zero being put in. ...
    (comp.lang.php)
  • Re: messing up code
    ... Now be VERY careful when inserting a string into a database. ...
    (microsoft.public.scripting.vbscript)
  • Re: open ADOQuery with SQL-2000 raise error message and close the application
    ... after much work on this case I figure out that the bug is when inserting ... > I take it you are trying to enter the null string into the database. ...
    (borland.public.delphi.database.ado)
  • Re: Deleting blanks in a string
    ... string and insert in a database. ... The problem is that in the database ... How can I remove the blanks before ... inserting in the database? ...
    (microsoft.public.dotnet.languages.vb)
  • Re: A little Rolodex [revised]
    ... including alpha sort and searching for any embedded string, ... In this application, a database is a directory, ... you may optionally provide any alternate UCASE program, ... NN -> first store NN as key length ...
    (comp.sys.hp48)