special characters to be inserted

Hi all
I tried to insert a string including special characters like apostrophe s ('s) using a richboxtext in vb6 to sql server 2000 database. I cant insert this string and I always get an error message. if I remove that ('s) then I can insert. please help me to find a solution soon.

thanks buddy

Have a look into SQl Escape characters

Moved to Database Development

Assuming you are using an SQL statement to do the insert, see the article How do I put the ' character into an SQL string? from the SQL section of our Database Development FAQs/Tutorials (at the top of this forum)