adding slashes 1

[stasJohn]

Is there a vb function like php's addslashes function?

Basically, I perform an sql statment like so...

select * from table where data = 'content\'s'

of course, content\'s is actually content's, and I need to add a slash before the apostrophe or else the query fails.

If there is no vb equivalent function, what method can I use?

thanks in advance

 

[RoyVidar]

In Access one often "double" the quotes with the replace function:

[tt]"select * from table where data= '" & replace(myvar,"'","''") & "'"[/tt]

Or if using DAO, one can use "double quoting" to allow special charachters:
[tt]"select * from table where data= """ & myvar & """"[/tt]

Roy-Vidar

 

[stasJohn]

the replace function worked great... thanks!!!