举例:
SELECT B1_APPL_CLASS FROM B1PERMIT
WHERE B1_APPL_CLASS COLLATE Latin1_General_CS_AS != UPPER('Complete')
SELECT B1_APPL_CLASS FROM B1PERMIT
WHERE B1_APPL_CLASS COLLATE Latin1_General_CS_AS != UPPER('Complete')
转载于:https://blog.51cto.com/zhaohui/341472