34,594
社区成员
发帖
与我相关
我的任务
分享
SELECT upper(JX) AS A,1 AS B,0 AS C FROM B_ZZBH WHERE ZZBH='QZ314' AND BDEL=1
SELECT lower(JX) AS A,1 AS B,0 AS C FROM B_ZZBH WHERE ZZBH='QZ314' AND BDEL=1
SELECT upper(JX) AS A,1 AS B,0 AS C FROM B_ZZBH WHERE ZZBH='QZ314' AND BDEL=1 COLLATE Chinese_PRC_CS_AS
sql 不区分大小写的,你是不是存的候是小写..
你确定没有记错
SELECT distinct JX from B_ZZBH 看看都有什么