C% will work for all the cases. Even if the data contains %, Using C% wil

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

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

Please Help Members By Posting Answers For Below Questions

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2951

What is the difference between oracle and db2?

1117

How to execute stored procedures?

1135

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

1187

When the like statement is used?

1227

What is the picture clause of null indicator variable?

1138

How to view db2 table structure?

1022

What is netezza database?

1032

Define db2 and its databases?

1059

What is a collection in db2?

1041

What is ibm db2 database?

1016

What is null value in db2?

1032

What's The Error Code For Unique Index Voilation?

1243

What is schema in db2?

1025

What language is db2 written in?

1051