Heya, Can anyone tell me if you can control the order in which SQL server executes the statements in a where clause??
http://www.sql-server-performance.com/transact_sql.asp for relevant information. HTH Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Actually I would leave this to the optimizer which usually does a good job. ----------------------- --Frank http://www.insidesql.de -----------------------