What are the SQL expressions for the Batch standalone filters?

Summary

The standalone version of QAS Batch uses ‘filters’ to decide to which records a certain action should be applied. This document gives the SQL expressions for each of these.

Filters

Verified Correct

(QAS_System like '[QR][9]??*' AND QAS_System like '??????????[4567cdef]?*' )

Good Full 

(QAS_System like '[QR][9]??*' AND QAS_System not like '??????????[4567cdef]?*' )

Good Premise Partial 

(QAS_System like '[PO][9]??*' AND QAS_System like '???????????[2367abef]*' )

Recommended Interactive Cleaning

( QAS_System like '[RQ][05]*' or QAS_System like '[RQ]9???????[1235679ABDEF]*' or QAS_System like '[ABDKLMNOP]*' )

Interactively Cleaned

(QAS_System like '[V]???*' OR QAS_System like '[U]???*' )

Interactively Accepted 

QAS_System like '[V]???*'

Tentative

QAS_System like '[QR][5]??*'

Poor Full 

QAS_System like '[QR][0]??*'

Multiple Matches 

QAS_System like '[MN]???*'

Partial 

QAS_System like '[OP]???*'

Truncated

( QAS_System like '[A-R]????????[1235679ABDEF]*' )

All Records

((QAS_System like '[QR][9]??*' AND QAS_System like '??????????[4567cdef]?*' ) OR (QAS_System like '[QR][9]??*' AND QAS_System not like '??????????[4567cdef]?*' ) OR (QAS_System like '[PO][9]??*' AND QAS_System like '???????????[2367abef]*' ) OR QAS_System like '[V]???*' OR QAS_System like '[QR][5]??*' OR QAS_System like '[QR][0]??*' OR QAS_System like '[MN]???*' OR QAS_System like '[OP]???*' OR QAS_System like '[C]???*' OR QAS_System like '[ABDKL]???*' OR QAS_System like '[U]???*' )