:: delimiting apostrophes to insert data w/o errors ::

[Hastie, Christa]

Hello!
I bet there is some really simple DBI function/reg ex that delimits the
apostrophes like such (\') so data can be inserted into the db without
errors.
 
i.e. this string:
INSERT INTO db (SomeColumn) VALUES ('John's car is cool!')
 
becomes:
INSERT INTO db (SomeColumn) VALUES ('John\'s car is cool!')
 
Anybody know the function/reg ex for this?
Thanks for any help in advance!
Appreciate it!
 
- christa :)
 
- - - - - - - - - - - - - - - - - - - - - - - - -
christa hastie