Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

string operations with BSP

Dear Friends..

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.

Naim

<table>

<TH>First Name</TH>

<TH>Last Name</TH>

<%

Loop at tests into test.

%>

<%

Search selname for 'A'.

" if sy-subrc = 0 .

%>

<tr>

<td><%= test-name_last %></td>

<td><%= test-name_first %></td>

</tr>

<%

"endif.

Endloop.

%>

</table>

select * from U_11104

into corresponding fields of table tests up to 100 rows

where NAME_LAST = 'A'.

replied

Hi,

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.

Best regards,

Guillaume

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question