topic Re: select query in Application Development and Automation Discussions

select query

Former Member — Mon, 15 Sep 2008 16:02:12 GMT

Hi ,

I want to retrieve all the records whose objid field begins with 'X'

If I give the following query its not working.

select * from table into itab where objid like 'X'.

Swarna.

Former Member — Mon, 15 Sep 2008 16:42:53 GMT

hi,

use the following,

select * from <table> into table <int table> where <fldnam> like 'X%'.

all d best.

Former Member — Mon, 15 Sep 2008 16:48:10 GMT

hi,

use the following,

select * from <table> into table <int tab> where objid like 'X%'.

all d best.