search case-insensitive.

[Former Member]

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.

[Former Member]

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.

[former_member194669]

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

a®

[Former Member]

י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

[former_member194669]

then poosible option my second thread option

a®

[Former Member]

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

[former_member194669]

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®

[vinod_vemuru2]

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.

[Former Member]

HI Vinod Vemuru

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

there is different way ?

Regards

James

[vinod_vemuru2]

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.

[former_member194669]

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®