作者在 2008-11-17 13:41:12 发布以下内容
先将数据库中该字段全部转为大写，然后用Upper()函数将条件转为大写：
select * from code_table_data t where Upper(t.DETAIL_DESC)=Upper('tr');
select * from code_table_data t where Upper(t.DETAIL_DESC)=Upper('tr');
select * from code_table_data t where Upper(t.DETAIL_DESC) like '%T%';
