topic Re: select with STAR value in Application Development and Automation Discussions

select with STAR value

former_member194669 — Tue, 24 Apr 2007 14:58:40 GMT

Hi All,

I have custom table with field that contains the * (star) values . ie


ABC*123
AB*1234
A*12345
A%12345
a&12345

I need to get values of all * entries using a select statement.

I don't need to select all and loop thru and filter it out

Any suggestions ?

Thanks

aRs

Re: select with STAR value

suresh_datti — Tue, 24 Apr 2007 15:01:50 GMT

you can try using the pattern search ie

select * from <dbtab> into table <itab>

where <fld> like '%*%'.

~Suresh

Re: select with STAR value

Former Member — Tue, 24 Apr 2007 15:06:34 GMT

Here you go,

for example,

SELECT... WHERE CITY LIKE '%town%'.

This condition is true if the column CITY contains a string containing the pattern ‘town’.

Regards,

Bhasha

Re: select with STAR value

Former Member — Tue, 24 Apr 2007 15:07:32 GMT

Hello aRs,

U can select like this.


data: var.
var = '*'.

select * from ztable where field like var.

Regards,

Vasanth

Re: select with STAR value

Former Member — Tue, 24 Apr 2007 15:08:30 GMT

Try this but not sure...

select <field> from table where field like '%*%'.

Thanks,

SKJ

Re: select with STAR value

Former Member — Tue, 24 Apr 2007 15:13:54 GMT

Hi,

You can build a wildcard ranges and please try something like this.


r_wildcard-sign =  'I'.
r_wildcard-option = 'CP'.
r_wildcard-low = 'B*'.
append r_wildcard.

r_wildcard-sign =  'I'.
r_wildcard-option = 'CP'.
r_wildcard-low = '*B*'.
append r_wildcard.
 
select * from mara
into table gt_mara_b
where mtart = 'YSAB'
and matnr in r_wildcard.

Regards,

Ferry Lianto