The spec does not seem to define the IN operand of a WHERE clause of an SQL
query.
It is mentioned in section 8.5.3 SQL EBNF:
whereexp ::= propname op value |
propname IS NULL |
propname IS NOT NULL |
value IN propname | <== mentioned here
like |
contains |
whereexp AND whereexp |
whereexp OR whereexp |
NOT whereexp |
'(' whereexp ')'
Following that, in 8.5.4.3 WHERE, there is a description of the WHERE clause
with no mention of the IN parameter at all. I cannot find a description of what
it means.
My question is: Are these two clauses identical?
WHERE 'xyz' IN NAME
WHERE NAME = 'xyz'
Or are these:
WHERE 'xyz' IN NAME
WHERE NAME LIKE '%xyz%'
Doug McComsey
Computer Associates
[EMAIL PROTECTED]
