>How can I make a search on a table field non case-sensitive?
>
>Thanks
>Kev

Kevin, try to apply UPPER() or LOWER() functions
For example:

my_search_string = UPPER("SoMeThInG")
LOCATE FOR UPPER(myfield) = my_search_string
To speed things up have an index on UPPER(myfield)

Nick