Skip to Content
0
Former Member
May 01, 2015 at 04:18 PM

Facing problem during select statment with wild card

13 Views

HI Experts,

I am facing a problem when writing a select statement using wild card.

I want to fetch the record whose entries are having like this _ _ _ _ 537_____,

That is I want all the records such that the record's 5th position should have 5,6th should have 3,7th should have 7

I am using the below select statement.

select short stext from hrp1000 into table lt_select_list

where short LIKE '_ _ _ _537%'.


But above select querry doesnt give any record,any could you suggest suitable solution


Note:i want dont want to use select short stext from hrp1000 into table lt_select_list where short LIKE '%537%'.it will give all not our intentended.



Thanks

kranthi