What are the various ways to ESCAPE single quotes(') in the SQL LIKE command?

One way is to put two single quotes whenever you have to escape a single quote.

Can you people suggest something?

Databases: SQL Server 2005 and Oracle 10g

Edit
Report