topic Re: search case-insensitive. in Application Development and Automation Discussions

search case-insensitive.

Former Member — Sun, 07 Feb 2010 08:28:20 GMT

HI All ,

i want to create program that use search from table but case-insensitive ,

How i can do that ?

Regards

James

SELECT agr_name UP TO iv_limit ROWS

FROM ZROLE

INTO TABLE lt_re_role

WHERE agr_name LIKE lv_search_value.

Re: search case-insensitive.

former_member194669 — Sun, 07 Feb 2010 08:33:03 GMT

Use the CS (Contains String) Function instead of the LIKE clause within your select

a®

Re: search case-insensitive.

vinod_vemuru2 — Sun, 07 Feb 2010 08:34:56 GMT

Hi,

If the database table field's dataelement is case sensitive then the search automatically happens in case sensitive mode.

You don't have to do explicitly.

Thanks,

Vinod.

Re: search case-insensitive.

former_member194669 — Sun, 07 Feb 2010 08:41:22 GMT

Otherwise


SELECT agr_name UP TO iv_limit ROWS
FROM ZROLE 
INTO TABLE lt_re_role
WHERE agr_name ne space.

then


LOOP AT lt_re_role .
IF lt_re_role-agr_name CS v_name.

a®

Re: search case-insensitive.

Former Member — Sun, 07 Feb 2010 08:44:22 GMT

יHI

when i try to add it to the select insted the like i get this error

"CS" is not a valid comparison operator. comparison operator.

Thanks

James

Re: search case-insensitive.

former_member194669 — Sun, 07 Feb 2010 08:49:23 GMT

then poosible option my second thread option

a®

Re: search case-insensitive.

Former Member — Sun, 07 Feb 2010 08:49:29 GMT

HI Vinod Vemuru

the field is domain but the lower case is not marked ,

there is different way ?

Regards

James

Re: search case-insensitive.

Former Member — Sun, 07 Feb 2010 08:56:45 GMT

HI a®s,

there is different option to do that since

I'm not sure about performance aspects since you collect all the data from the table

and than you do the logic .

Thanks and Regards

James

Re: search case-insensitive.

former_member194669 — Sun, 07 Feb 2010 09:02:16 GMT

This may be my another suggestion.

Can it be create & maintain another field in the table ZROLE with UPPER case value of field agr_name ?

then you make select on that field

This is only a suggestion

a®

Re: search case-insensitive.

vinod_vemuru2 — Sun, 07 Feb 2010 09:04:34 GMT

Hi,

If the definition is not case sensitive, then always the data is stored in CAPS by default.

So what u can do it, translate your string to UPPER CASE and then select.

Place below statement just before your select.

TRANSLATE lv_search_value TO UPPER CASE.

SELECT agr_name UP TO iv_limit ROWS

FROM ZROLE

INTO TABLE lt_re_role

WHERE agr_name LIKE lv_search_value.

Thanks,

Vinod.