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

What is the maximum No of rows per page?

1063

How do you eliminate duplicate values in db2?

1162

What is a bind in db2?

1037

What r the comman abends in db2, jcl and cobol???????

2250

Define db2 and its databases?

1048

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1074

What is the role of schema in the db2 database?

1263

What is dclgen in db2?

1137

Which component is responsible for db2 startup and shutdown?

1031

What is ibm db2 used for?

1067

What is the max length of sqlca?

1212

How can you count the number of rows from a table tab?

1083

What are the uses of db2 optimizer?

1288

What is the physical storage length of timestamp data type?

1086

What is an instance in db2?

1027