>>>>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
Go raibh maith agat
~M