Case sensitive Searh field

[Former Member]

I made a look up field where in they could search text from the description field. But it don't give results if I tried to search using uppercase and if it's different from the records of the table. I already asked the basis but he has no idea. Please help me on this. Thank you!

[Former Member]

Hi Maui,

Did u try the FIND command with the addition IGNORING CASE option??

FIND

Basic form

FIND p IN [SECTION OFFSET off LENGTH len OF] text.

Extras:

1. ... IGNORING CASE.

The text is always case sensitive and the comparison is done character by character.

Try the above option . Hope this helps.

Cheers

VJ

[Former Member]

Hi Maui,

Did u try the FIND command with the addition IGNORING CASE option??

FIND

Basic form

FIND p IN [SECTION OFFSET off LENGTH len OF] text.

Extras:

1. ... IGNORING CASE.

The text is always case sensitive and the comparison is done character by character.

Try the above option . Hope this helps.

Cheers

VJ