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'%';

How to connect to db2 database from windows command line?

0 Answers  

What is the difference between SYNONYM and ALIAS?

6 Answers   TCS,

How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).

2 Answers   IBM, Infosys,

What are column-name qualifiers used?

1 Answers  

What is node in db2?

0 Answers  

What are the various locking levels available?

3 Answers  

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

0 Answers  

SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers   Cognizant,

How to define the a field which accepts value till 99999.99 in db2

3 Answers  

which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?

3 Answers  

What is a NULL value? What are the pros and cons of using NULLS?

2 Answers  

what is datacom db?

2 Answers   CSC,