The following returns 1:

SELECT 'T' COLLATE NOCASE IN('t');