topic Re: Problem in using LIKE addition in SELECT statement in Application Development and Automation Discussions

Problem in using LIKE addition in SELECT statement

Former Member — Tue, 09 Feb 2010 12:53:58 GMT

HI Experts,

Have a small query for you :

While selecting from Database I want to fetch all records which have the field name like "HR_".

I wrote following select query :

l_tsobj TYPE tst01-dname VALUE 'HR_%',

SELECT * INTO TABLE ltst01 FROM tst01 WHERE dname LIKE l_tsobj.

During debugging it shows me all records like HR_ & all records like HRL.

Not sure why it is fetching records like HRL from database .

In table tst01 total number of records having HR_ = 1231

but the above query select in total 1231 + 2000( records having HRL ..... pattern also ).

I want to restrict data selection at database level only & not at internal table level . Please suggest.

Thanks,

Abhinav.

Former Member — Tue, 09 Feb 2010 13:00:02 GMT

try this..

data : l_tsobj TYPE STRING VALUE 'HR_%',

Former Member — Tue, 09 Feb 2010 13:07:20 GMT

Hi,

you have to use ESCAPE statement.


DATA:      
  l_tsobj TYPE tst01-dname VALUE 'HR/_%'.

SELECT * 
  INTO TABLE ltst01 
  FROM tst01 
  WHERE dname LIKE l_tsobj ESCAPE '/'.

Regards Marcel

Former Member — Tue, 09 Feb 2010 13:08:23 GMT

Doesn't help already tried that

Former Member — Tue, 09 Feb 2010 13:11:24 GMT

thanks Marcel it resolved my problem...