Question...

I'm porting some VFP queries into SQL server, and have a question about embedding IIF() functions...

I have a VFP query where I'm summing certain fields based on an Invoice type. In VFP, I do the following

SELECT , SUM(IIF(InvType='01',Qty * UnitPrice,0)) AS TotDollars...

What is the best way to do this in Transact-SQL? The only thing I've come across that would seem to work is a SELECT CASE statement in the query, though my question is how much this would affect performance when working on a large file.

Thanks,
Kevin

"Run, you clever boy....and remember"
https://www.youtube.com/watch?v=8U4Y2Uv8ArM

"My survival...my living proof"
https://plus.google.com/photos/117162300364810952313/albums/5876836271056272097/5876836294121419858?banner=pwa&pid=5876836294121419858&oid=117162300364810952313