>>>>Try to use parameters instead:
>>>>

>>>>text to lcSQLCommand noshow
>>>>Insert into Contacts ([Contact Name]) 
>>>>values (?m.lcName)
>>>
>>>endtext
>>>
>>>>SQLEXEC(m.lnSQLHandler, m.lcSQLcommand)

>>
>>... and to add to why you may want to use parameters (aside from the original question about problem caused by apostrophe within name):
>>https://www.w3schools.com/sql/sql_injection.asp
>>https://xkcd.com/327/
>
>Thanks but I am already aware why I would want to use parameters :) I assume you meant to send to Mark instead.
Thanks all.
~M