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 / guest

C% will work for all the cases. Even if the data contains
%, Using C% will fetch that too.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about dbrm.

798


Outputs of explain are with matchcols = 0. What does this signify?

850


What is db2 stogroup?

901


Is db2 free?

871


How to rename a table in DB2 ?

832


What is the difference between bind and rebind in db2?

1199


Can one database have multiple instances?

821


How many databases are there?

797


Why db2 is called db2?

790


What is the use of reorg in db2?

837


Can we update view in db2?

780


What are the contents of a dclmgen?

856


Explain package in db2 and its advantages?

869


what is utility for parm lib

2108


What is package in cobol db2?

881