hello,.. I have a problem with an sql statement and the insert into command.

say the string I want to insert is THAI'S POST

well since it has a ', how do you make it work with sql without making the string a variable? any suggestions?

thanks,
Thai