Oracle Equivalent of 'IN'

[TomSalvato]

Hi All,

I'm writing an SQL Expression field, and I need the Oracle equivalent of the following ...

"TABLE"."WORK_TYPE" in ['1', '10', '12']

* I know I can break it down by a bunch of 'OR' lines, but I figured there should be an 'IN' equivalent that I could use.

Thanx in advance!

-TS

 

[lbass]

Just use parentheses instead of square brackets.

"TABLE"."WORK_TYPE" in ('1', '10', '12')

-LB

 

[TomSalvato]

Yup, that's what I needed.

Thanx again, LB!

-TS