Where clause condition help

[itchyII]

Hi All,
I am pretty new to SQL. I have a simple query, and I am trying to figure out how to add a condition to my where clause. The query looks something like this:

SELECT     tblItem.fldItemId, tblItem.fldInDate, tblItem.fldStartDate, tblItem.fldSchStart, tblItem.fldScopeId
FROM         tblItem

What I would like to add now is a condition in the WHERE clause that will select on those records based on something like:

if tblItem.fldScopeId = 1
then tblItem.fldInDate <> tblItem.fldSchStart
else tblItem.fldInDate <> tblItem.fldStartDate

It sounds simple, but I don't know the syntax!

Thank you in advance!

 

[bborissov]

WHERE
  (tblItem.fldScopeId = 1 AND tblItem.fldInDate <> tblItem.fldSchStart) OR
  (tblItem.fldScopeId <> 1 AND 
else tblItem.fldInDate <> tblItem.fldStartDate)

or:

WHERE tblItem.fldInDate <> CASE WHEN tblItem.fldScopeId = 1
                                     THEN tblItem.fldSchStart
                                ELSE  tblItem.fldStartDate
                           END

not tested!!!!!!!!

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[bborissov]

Grrrrrrrrrr.
Have typo in first example.
It should be:

WHERE
  (tblItem.fldScopeId = 1  AND tblItem.fldInDate <> tblItem.fldSchStart) OR
  (tblItem.fldScopeId <> 1 AND tblItem.fldInDate <> tblItem.fldStartDate)

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[itchyII]

That's perfect! Thanks!!!