How to specify ignore case in when statement in Sybase

sql, sybase

Solution

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

Problem

How to specify ignore case in a `where` statement in Sybase? Basically I want ``` select * from _table where _field = 'BUSY' ``` to return rows if there are any rows with values like 'BuSy' in field `_field`.

Original source