string operations with BSP
How are you... I m facing little problem in string oprations. I wish to search given character from the Name and display on those name who has the given charecter. say, i have search term as A, then it should display the names who has A in the spelling, please help me to short out this problem i have given you the code of it,
thanking you regards.
Loop at tests into test.
Search selname for 'A'.
" if sy-subrc = 0 .
<td><%= test-name_last %></td>
<td><%= test-name_first %></td>
select * from U_11104
into corresponding fields of table tests up to 100 rows
where NAME_LAST = 'A'.
Your question is more about SQL in fact...
Try this :
select * from U_11104 into corresponding fields of table tests up to 100 rows where NAME_LAST LIKE '%A%'.
That should solve your problem.