topic Re: Select Query in Application Development and Automation Discussions

Select Query

Former Member — Thu, 07 Feb 2008 07:10:18 GMT

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 — Thu, 07 Feb 2008 07:15:01 GMT

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

Former Member — Thu, 07 Feb 2008 07:16:09 GMT

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

Former Member — Thu, 07 Feb 2008 07:16:18 GMT

Hi,

SELECT * from <dbtab> into table <itab>

where objnr LIKE 'PR%'.

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

Vijay — Thu, 07 Feb 2008 07:18:06 GMT

try like this

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

REGARDS

vijay

reward points if helpful

Former Member — Thu, 07 Feb 2008 07:27:56 GMT

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.