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
6241 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 a buffer in memory?

1047

How do I change the column size in db2?

1136

What is the use of dclgen in db2?

1067

How to execute stored procedure in db2 command editor?

1037

Is the primary key a clustered index?

1127

Define sqlca.

1095

How do I optimize a query in db2?

1085

Name the various locking levels available?

1084

What is the use of db2 optimizer?

1089

What is dclgen (declaration generator)?

1037

What is table space in db2?

1008

On which levels locks can be applied?

1111

What do you mean by between and in? Is between inclusive of specified range values?

1081

What is db2 instance?

1058

What is the difference between using bind () and rebind () methods of naming class?

1376