如何使用SQL语句来实现忽略大小写的查询!

[snowredfox]

比如表test中有A字段有几条记录的字段值为,"AAAA",AaAa","AAaa"...

select A from test where A = 'aaaa' 能够得到上面所有的记录!

[bzszp]

select lower(A) from test where A = 'aaaa'

[bzszp]

SQL> SELECT NA FROM (SELECT LOWER(NAME) NA FROM B) WHERE NA='aa';

NA
--
aa

[black_dragon]

select A from test where lower(A)='aaaa'

[snowredfox]

this:
select lower(A) from test where A = 'aaaa';

or this:
select A from test where lower(A)='aaaa';

???

[biti_rainy]

select a from test where upper(a) = 'AAAA';
灌水,呵呵