Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Case sensitive Searh field

Go to solution
Former Member

‎2006 May 29 3:18 AM

0 Likes
326

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!

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2006 May 29 3:28 AM

0 Likes
302

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

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!

Reply
1 REPLY 1
Read only

Go to solution
Former Member

‎2006 May 29 3:28 AM

0 Likes
303

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