>>You need to double the apostrophe or use parameter (preferred method).
>
>Say the parameter is not applicable and you only have an option of what you call "double the apostrophe." Then user enters "O'Connell", do you mean to search within the entry (before adding it to the SQL Select) and add another single apostrophe as "O''Connell"?

The simplest way is

lcNewSQL = strtran(lcOldSQL,['],['']) && in VFP code.