string operations with BSP

[naimkhans_babi]

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'.

[guillaume-hrc · Accepted solution]

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

[naimkhans_babi · Accepted solution]

thanx for you reply

i m failed to have the output... do you know n e another way to do

please

thanking you..

[naimkhans_babi · Accepted solution]

I am extremly sorry...my mistake i made = A instead of liek A it is working nicely, i am sorry once again