举例:

SELECT B1_APPL_CLASS FROM B1PERMIT
WHERE B1_APPL_CLASS COLLATE Latin1_General_CS_AS != UPPER('Complete')