Stephan, > Spec thing. > > In SQL92, > "X BETWEEN Y AND Z" is equivalent to "X>=Y AND X<=Z". > > In SQL99, there's BETWEEN SYMMETRIC and ASYMMETRIC, but ASYMMETRIC is the > default which is the same as the SQL92 version afaics. Symmetric is an > optional feature that I think Christopher's been working on.
Thanks. Thought it was something like that. Thank you guys, though, OVERLAPS is asymmetric. -- -Josh Berkus ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology [EMAIL PROTECTED] and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster