Answer / mdvasanth86

Anand is right.


SELECT * FROM table_name WHERE column_name LIKE 'C!%'
ESCAPE'!';


If you want to use % or _ as part of your like clause,
you must have an escape character before each occurrence of
% or _ and define what the escape character is like above.

So, an escape character before the % or _ will make it part
of the string rather than a wildcard character(S).


HTH

Answer / bala

Use '%%' to select the data which contains %

Answer / guest

C% will work for all the cases. Even if the data contains
%, Using C% will fetch that too.

Answer / prachi

SELECT NAME FROM EMP WHERE NAME LIKE 'C%';

Answer / anand

hi,
it may be correct ans.check out this..
SELECT * FROM table_name WHERE column_name LIKE 'C%%'
ESCAPE'%';

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

What is the difference between spufi and qmf?

0 Answers  

What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,

how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,

What is dbrm? What it contains?

0 Answers  

How can you split a table in to exactly half?

7 Answers   HSBC,

Request to database but database is not available so what is was abend is raised?

2 Answers   UST,

What are foreign keys in db2?

0 Answers  

What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,

How to check table size in db2 sap?

0 Answers  

What is the meaning of -805 SQL return code?

3 Answers  

What is a synonym ?

2 Answers