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
6229 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

When reorg is used?

1106

What is a cursor in programming?

1044

Define sqlca.

1090

What language is db2 written in?

1025

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3138

What is the reason behind not using select * in embedded sql programs?

1084

What is iseries database?

1033

What is dpf in db2?

1087

What db2 400?

1143

What is consistency token in db2?

1112

What is cursor with hold option in db2?

1052

What is dbrm?

1084

What are host variables in db2?

1025

What is difference between alias and synonym in db2?

1118

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1048