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

Generally if I want to select the names starting with c I
need to use c%
But how could I code to select the data which contains %
as a part of data.

Question Posted / prachi

Answer Posted / prachi

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to check table size in db2 sap?

1095

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1312

Can there be more than one cursor open for any program?

1223

What is deadlock in db2?

1118

What is the use of predicate?

1085

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1109

What is the maximum size of varchar data type in db2?

1174

How will you return the number of records in table?

986

What is nvl in db2?

1147

What is a db2 cursor?

1107

What are the different types of base tables?

1161

What is cloudant database?

1154

What is rct?

1287

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

3007

Which is faster delete or truncate?

1175