select Y from <table> where substr(y,1,3) = 'abc' we can

in column y record
abc.v
abc.s
xyz.j
abc.h
i wan only abc columns
how to retrieve thi records

Question Posted / madhu t

2 Answers
6270 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / madhu t

select Y from <table> where substr(y,1,3) = 'abc'

we can achieve this by using substring function in sql.
SUBSTR(column-name,starting-position,length)

Is This Answer Correct ?

12 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is blu acceleration in db2?

1069

What is rebind in db2?

1054

How connect db2 database to datastage?

1235

What does reorg do in db2?

1026

What is database manager in db2?

1017

How do you select a row using indexes in db2?

1135

Explain various types of locks in db2?

1140

What are concurrency issues?

1095

What is meant by union and union all?

1008

What is the role of the data page in the db2 database?

1025

What is rct?

1229

How would you find out the total number of rows in a db2 table?

1050

Give the name of some fields form sqlca.

1075

What is the use of value function?

1147

What is meant by explain?

1130