CAS 6


in
- Relational

Summary

Membership in a list. Where there is only 1 item in the list 'in' is equivalent to 'eq'. The function case sensitive.

Examples

STATE in 'NY,CT,NJ'
LOANID in '1000032'
ORIGTERM in 180 460
not PROPTYPE in 'C,CLR,CHR,PUD,DPUD'

Syntax

RightInput in LeftInput

Left Arguments

Name Data Type Input Type Description Optional Default
LeftInput Numeric, Text, Date Field Data No

Right Arguments

Name Data Type Input Type Description Optional Default
RightInput Numeric, Text, Date Field, Constant Text Search items delimited by commas or numeric value No

Result

Type: Boolean

1=Item in list, 0=item not in list



Build 6.0.624