ANY operator in SQL Server

[Uma Kameswari]

Hi, Again I am back with ANY operator:) can anyone give me an example of how to use any operator in sql server? Regards, Uma

[Pete OHanlon]

SELECT Col1, Col2, Col3
FROM TABLE1 WHERE
Col4 >= ANY
( SELECT Col1 FROM TABLE2 WHERE DateAdded >= '21-Oct-2006')

the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.