Select Query

[Former Member]

Hi,

I want to write a select query to fetch the records, which has field (say objnr) should start with "PR"

I tried giving as follows:

SELECT * from <dbtab> into table <itab> where objnr = 'PR%'.

But the output is not coming.

What is the correct way to fetch only those records?

Regards,

Kalai

[Former Member]

SELECT * from <dbtab> into table <itab> where objnr like 'PR%'.

[Former Member]

SELECT * from <dbtab> into table <itab> where objnr like 'PR%'.

[Former Member]

USE LIKE SELECT * from <dbtab> into table <itab> where objnr LIKE 'PR%'.

[Former Member]

Hi,

SELECT * from <dbtab> into table <itab>

where objnr LIKE 'PR%'.

Don't forget to reward if useful....

[Vijay]

hi

try like this

SELECT * from <dbtab> into table <itab> where objnr CP 'PR'.

REGARDS

vijay

reward points if helpful

[Former Member]

Hi,

please go through the below code i hopw it will u an idea.

Select single <PRECEDENCE>

FROM <tab>

INTO TABLE <ITAB>

WHERE OBJNR LIKE 'PR%'

UPTO 100 ROWS.

Regards.