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.
Answer Posted / prachi
SELECT NAME FROM EMP WHERE NAME LIKE 'C%';
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain dclgen.
What is iseries database?
define clustering index.
What is db2?
What is the difference between dbm cfg and db cfg file in db2 ?
What is dbrm? What it contains?
How to create backup table in db2?
Explain in brief how does db2 determine what lock-size to use?
What is the maximum size of a char data type in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Why select is not preferred in embedded sql programs?
How can you quickly find out the # of rows updated after an update statement?
What is the physical storage length of time data type?
List out the data types available.
what is db2 restart?