Database explorer search problem

[hungerford1]

hi when i search the database explorer my search will not show any aircraft that are in lower case letters and i cannot change to lower case in the search box does anybody know how to resolve this problem, other than changing all the data to upper case. thank you

[tarbat]

Which field are you searching on?  I just searched for BOEING in the AN field, and all the lower case Boeing's appeared okay.

[hungerford1]

It doesn't work in any field for me i can only find upper case results and search in upper case. a bit frustrating as most records are lower caser.

[tarbat]

What exactly are you entering?  I use Text to Find = BOEING, Condition = IN, and Field = AN.

[hungerford1]

just tried condition - IN and it worked, i've been using 'BY'  for so long forgot to check 'IN' thanks for your help, much easier now.