How to specify ignore argument in when statement in Sybase

Question

How to specify ignore argument in where expression in Sybase ?

Basically i want

  select * from _table where _field = 'BUSY' 

to return strings if there are strings in the _field field with values ​​such as "BuSy".

Answer 1

 select * from _table where UPPER(_field) = 'BUSY' 

Answer 2

AFAIK, using a function in an indexed column will not allow the optimizer to use this index. The easiest way is to rewrite the operator to:

 select * from _table where _field like '[bB][uU][sS][yY]' 

this should allow the optimizer to use the index.

Answer 3

Your only choice is Transact SQL functions. This page lists all of them.