regarding the select query

Former Member — Mon, 19 Nov 2007 13:34:41 GMT

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

Re: regarding the select query

Former Member — Mon, 19 Nov 2007 13:42:51 GMT

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