case insensitivity

here is simple query
SELECT * FROM BFTITLE WHERE RFNAME='HITLER';
but if i want to select hitler LOWER leave case this query is not valid so how can we right query to select all type of hitler(case type)sql server is by default case insensitive. if someone has changed the default collation, you can use the UPPER and LOWER functions.|||well what you can do is change your where clause by changing the search type to either upper or lower....something like

SELECT * FROM BFTITLE WHERE upper(RFNAME)=upper('HITLER');
OR
SELECT * FROM BFTITLE WHERE lower(RFNAME)=lower('HITLER');