escape character within sql statement.

[Muslim Adamji]

Hi,
Following statement was working fine untill recently when someone entered specail 
characters in insert statement.

eg

insert in db (col1,col2) values('a1','a2');
where a1="Here's"
a2="Your's"

thats is when apostrope is applied.

Thanks
Adamji