>>>How can I use the REPLACE command with a field that contains an apostrophe in it? For example, REPLACE cPrefix WITH "Women's Hospital, Flint" WHERE blah, blah ...
>>>
>>>thanks
>>
>>I tried that command just now and it worked. If you surround it with double quotes it should work. What error are you getting?
>
>If the intent is to replace the field with exactly "Women's Hospital, Flint", trying putting it into a variable, like this
>
>repstr = '"Women'+"'s Hospital, Flint"+'"'

I tried your way which put quotes around it, which you dont need. So I changed it to:

repstr = 'Women'+"'s Hospital, Flint"

And it replaced ok with the statement:

replace fieldname with repstr

I did not have a condition after it though.