Ways to escape single quotes in SQL 'LIKE' command

Question

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

Answer 1

You already have the answer. You have to use two single quotes:

select * from table where field like '%''something''%'