regarding the select query

[Former Member]

Hi all,

I need to fetch the documents from the database table where the

field <b>f1</b> equal to SPACE or in f1 column the records should start

with either 03 or 01.

can any one suggest how to pickup the records which should start with

either 03 or 01 from the database table.

any suggestion will be rewarded.

Regards

cnu

[Former Member]

Hi,

Do like this

Select f1 f2 f3 from DB Table into ITAB where F1 like '03%' or F1 like '01%' or F1 = ' '.

Reward if this helps,

Satish