sql question

[Ruslan Zasukhin]

on 12/5/03 11:21 AM, katy kuzemsky at katy at ociwen.com wrote:

Hi Katy,

> (V4MD198)
> I would like a precison about the "In" operator.
> sql = select * from table where champ in (subquery) : that's ok
> 
> 
> What is the correct syntax to use the "in" operator with several value?
> (these values are not the result of a subquery)
> 
> a) sql = select * from table where champ in (value1, value2, etc)
    
    this one correct


> b) sql = select * from table where champ in [value1, value2, etc]

no

> c) not implemented in this version of v4md

implemented

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------