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

What is the purpose of using commit?

629


Is db2 a programming language?

616


What is the syntax for creating a table in the db2 database?

637


Is db2 a mainframe database?

575


How to rename a table in DB2 ?

647






I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1946


Explain dclgen.

733


What are the contents of dclgen?

665


How connect db2 database to datastage?

780


What is with ur in db2?

772


What are the prerogatives?

628


How to find the maximum value in a column in the db2 database?

623


What is database manager in db2?

561


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

714


Can we insert update delete in view?

585