Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  if condition within sql statement

Author  Topic  fish Starting Member 3 Posts Posted - 2000-08-20 : 21:25:47 I am calling a sql statement within asp. i am selecting one field from one table but the where clause has two possible outcomes. I can do the if then in two statements, but was hoping to help performance and do it in one call. I need to select field from fieldtable where (this condition) or (this condition). thanks for your help. Take it easy, The Composer