There is a % sign in one field of a column. What will be the query to find it?

SELECT * FROM TABLE1 WHERE COL1 LIKE ''%' ESCAPE ''

correct syntax is 
SELECT * FROM TABLE WHERE COL LIKE '%9!%%' ESCAPE '!' 
THIS RETURNS THE VALUES THAT CONTAIN 9% 
THE FIRST AND THE LAST PERCENT SIGNS ARE WILDCARD CHARACTERS AND " ! " SIGN IS THE ECAPE CHARACTER.

select * from table where col1 like '%%%' ESCAPE ''

suppose consider a table named as symbol containing

SQL> select * from symbol;

CHARACTER  NAME
---------- ----------
%          modfun
#          hash

SQL> select * from symbol where character='%';

CHARACTER  NAME
---------- ----------
%          modfun

use escape key word.Example a string is like this aru%n.In this u want to find the %.Then use like 'aru#%#%'escape#.Try this

select * from dept where 1=decode(instr(loc,'%'),0,0,1)

select * from tab_name where col_name like '%\%%' escape '\';

select * from table_name where col_name like '% \% %' escape '\';

We have to use ESCAPE character.

If job column if emp table has '%' ex.('vb%dev') then

SELECT * FROM EMP where job like '%/%%' escape '/'

Here '/' ESCAPE character

select * from emp where instr('ename','%')!=0

SELECT *
FROM table_nm
WHERE col_nm LIKE '%/%' escape'/';

select *
from table_name
where code in
                      (select code
                        from table_name
                        where instr(column_name,'%') 
                        and instr(column_name,'%') > 0);



Regards
Dharmendra Jaiswal.

SQL> select * from name;

NAME
--------------------
Girija%Sankar
Girija,Sankar

SQL> select * from name where name like '%%%' escape '';

NAME
--------------------
Girija%Sankar

consider that a person have a name like this 'k%ng'
He can be found by


last_name like'k@%ng'

the query is to find the name of the person starting with a
here is an example
select ename from emp where ename like a%;

select * from emp where ename like ki\%ng escape ;

The below code will select the row having column as %

Code
SELECT * 
FROM table_name
WHERE column_name LIKE !%escape! 
 

The below code selects the column with a substring % (e.g.) reg%istration

Code
SELECT * FROM game WHERE name LIKE %\%% escape ;