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