>That second WHEN should be OR I think.
>

That's the original requirement

IIF(((TRANCODE="PR") .OR. (TRANCODE = "PT" .AND. TRANQUANT > 0)),TRANQUANT,0) AS Recepit

so it translates into 2 case statements.


>>The problem now is that SQL doesn't seem to like the 'AND' in the second CASE line.
>>

>>CASE tr.sTrans_Type_CD
>>	WHEN 'PR' THEN tr.decTrans_Qty
>>	WHEN ('PT' AND tr.decTrans_Qty > 0) THEN tr.decTrans_Qty
>>	ELSE 0
>>END AS Receipt
>>

>>
>>"Incorrect syntax near the keyword 'AND'."
>>
>>
>>>>
>>>>SQL doesn't like the 'OR's and 'AND's
>>><snip>
>>>T-SQL doesn't like '.' (dots) arround them. There's no need to use dots in VFP either.
>>>

>>>CASE WHEN (TRANCODE = 'PR') OR (TRANCODE = 'PT' AND TRANQUANT > 0) THEN TRANQUANT
>>>     ELSE 0 END AS Recepit
>>>