I am doing an insert:

sSql = "Insert " & _
"Into GWC.Cert_Agnc_Hldr " & _
"(agnc_num, hldr_name) " & _
"Values('" & sAgncNum & "', '" & sDsplyName "')"

The problem is that I ran across a value for sDsplyName that was: Mac's.
when it runs into this particular value for name, it gives me an error because of the apostrophe. Is there any way to do this without removing the ' from Mac's?
Thanks,
Ryan Uhl