Search for table entries with mixed case(Upper and Lower Case)

[Former Member]

Hi All,

I have a table with entries like

Test

TEST1

I have a search help for this filed,

1)If i give t* or T* it gives me both the records

This works fine

2) If i give te* or TE* or tE* or Te* i get only TEST1, but i want both to be displayed

Does any have any idea as to how to do this

Thanks

[Former Member]

Any suggestions ....

[Former Member]

>

> Any suggestions ....

Yes - search the forum. This question has been asked and answered many times before.

Rob

[Former Member]

If you are using Parameters or SELECT-OPTIONS use addition LOWER CASE and then use Help.

EX:

Parameters : <FIELDNAME> TYPE <Reference> Lower Case.

SELECT-OPTIONS : <FIELDNAME> FOR <Reference> Lower case.

Hope this solves the issue.

Regards,

Gurpreet