You'll have to write it out in longhand using logical operator
-or. Suggest consulting the Language Guide, p.174, for a
relevant example.

Also which version of FM? That makes a difference between 9+ or 8-.

--steve


On 6/26/13 at 2:02 PM, dabrams@apple.com pronounced:

>I need to query a FileMaker data source where a particular
>field has three possibilities ('active', 'inactive',
>'pending'). People can be both 'pending' and 'active' or
>'pending' and 'inactive', or just one of the three. So, I
>cannot say 'status'='pending' because it will leave out people
>that have multiple items. What I need is really a MySQL IN
>operator. What is the equivalent in Lasso Inline/FileMaker?
>
>
>
>#############################################################
>
>Attend the Lasso Developer Conference 2013!
>Sept 12-14, 2013 in Niagara Falls, Canada
>http://www.lassosoft.com/LDC-niagara-falls-2013
>
>#############################################################
>This message is sent to you because you are subscribed to
>the mailing list Lasso
>Lasso@lists.lassosoft.com
>To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
>Send administrative queries to <Lasso-request@lists.lassosoft.com>

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
Steve Piercy Web Site Builder
Soquel, CA
<web@StevePiercy.com> <http://www.StevePiercy.com/>


#############################################################

Attend the Lasso Developer Conference 2013!
Sept 12-14, 2013 in Niagara Falls, Canada
http://www.lassosoft.com/LDC-niagara-falls-2013

#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso
Lasso@lists.lassosoft.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>