Hi, I just ran into a serious problem ( well for me it is ).
I'm developing a website, which allows the user to send each other messages in the form of mail. I store the message into my database and display it when needed.

Well the problem is this:

"INSERT INTO tblSomething( fldMessage ) VALUES( '" & strMessage & "' )"

The database will complain about this statement because strMessage may have ('), which well delimate the string value.

Is there an easier way to handle this situation rather than going through each character in strMessage and changing the (') to its code???

That could be devistating to the speed.