VB Forum / Database Access / February 2004

How can I manage the apostrophe simbol (') in the SQL
Insert Into command? I'm using VB 6.0, ADO and SQL Server
2000.
When I do this: Insert into Table1 Values ('001','Jake's')

H
the  table had 35 fields and 30.000 record ( ADO connections/ mors.update
when I save a new record ( ADO connections/ mors.update    !first_name = txt_first_name )
it take 2 minutes  to save the recor

Could anyone help me with this Please. I want to write an SQL statement in VB.
A user enters a start date using inputbox. Sql statement searches database with
two fields,
BeginField and EndField. If date entered by the user exist within the range