Report to retrieve special character data

[Former Member]

Hi,

i have one query,

on my selection screen there is a select option for account number and based on this account number i am retrieving data from table.

suppose i have entered account number as 12345 then program is retrieving data for 12345 only. but in table there are account number 12345# also.

if i have entered account number on selection screen as 12345 then program needs to pull data for 12345 and 12345# .

please let me know what i have to do.

[former_member156446]

before updateing to the table why dont you pass it thru convert_exit_aplha_* fm and padd the account number with 00000 to fill the space...

else you need to find the string lenth.. and remove the #

else if you are using download or upload use Binary BIN mode rather than ASC

[Former Member]

write this select statement for your requirement:

select field1 field2 ...from <dbtable> into <target itab> where <accountno field > like '1234%'.

Reward if useful.

Dara.

[Former Member]

Hi,

1.In select query ,where account number Like '12345'.

SELECT * FROM cdpos

WHERE tabkey LIKE '000030_____PR00%'.

Regards,

Shiva.

[Former Member]

but i am using select-option

[asik_shameem]

Hi,

For that we have to modify the select-options table.

select-options: s_account for table-account.

concatenate s_account-low '*' into s_account-low. 

s_account-option = 'CP'.

s_account-sign = 'I'.

modify s_account index 1.