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

i want to maintain uniqueness on pdf without make lf??????????

1633


How to find the number of rows in db2 tables?

615


How do I change the column size in db2?

589


What is meant by explain?

660


How do I add a column in db2?

589






Describe major components of db2?

638


How to create db2 table in mainframe?

629


What do you mean by storage group (stogroup)?

581


What is a buffer in memory?

598


What is the function of logging in the db2 database?

638


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

747


What are the uses of db2 optimizer?

815


Name the lockable units in DB2?

663


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

579


What is the difference between cursor stability and repeatable read isolation levels?

678