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 does sqlcabc has?

1006

How is the value function used?

1097

What is the difference between spufi and qmf?

1069

What is buffer pool and list some of them?

994

What is load utility in db2?

1147

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

2220

Can one database have multiple instances?

1021

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1022

Why db2 is called db2?

981

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1051

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1129

Why do we bind in db2?

1164

Explain how can you do the explain of a dynamic sql statement?

1078

What is netezza database?

970

How can deadlocks be resolved?

905