In Operator

Used to control if a value is included in a list.

Material IN ('Crude" , 'Crude1' , 'Crude2' )

Any material name equal to Crude or Crude1 or Crude2.

Value IN (100, 200, 300)

Any value equal to 100 or 200 or 300.