Oracle 9i

Is there a way (an escape character) to get a tick in the selection criteria without getting the error:
"ORA-01756 quoted sting not properaly teminated"?


For example
select 'Ted's assignment' from dual;