select query

[Former Member]

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]

hi,

use the following,

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

all d best.

[Former Member]

hi,

use the following,

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

all d best.

[Former Member]

hi,

use the following,

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

all d best.