Oh I see...I understand now.  Thanks for sharing your knowledge.  It's very valuable.

I will modify my SQL Server code and examine the...

My resultset was different.  I think I may have translated the remaing MySQL code incorrectly.  Here is the MySQL code.

  , If(!isnull(PayDay), (altValue * 1), 0) as...

It works...why wouldn't it?  I just need to add an ELSE statement, and it will produce results.

But I'm going to try yours to see if it produces a different...

Nothing was wrong...except that it was harder to read(at least for my eyes).

Is the version I posted the same, technically, as yours?

Here's yours:

CASE WHEN PayDay IS NOT NULL THEN...

Hey, I'm a Grasshopper now!

wow...are you employed by sqlservercentral.com? 

Anyway, I wrote it out like this in SQL Server Query Analyzer:

altValue=CASE

WHEN PayDay IS NOT NULL

THEN (SELECT altValue AS TotPaid)

Thanks, I'll give it a try

wow, you have like 5000 posts..that's crazy! 

It doesn't sound right...I can't imagine how it could be a CASE statement....

So, to translate, it's an option in a CASE statement

When PayDay isn't null, then it...

gee, they waited 5 years for a new release?  I guess there is nothing wrong with that if it works.  Thank you!

wow, thanks guys...I appreciate your suggestions!

I'm actually VERY new to SQL Server.   I have  a tad bit of open-source SQL programming, but nothing too advanced. 

I'm looking to advance both my SQL knowledge and SQL...

Thank you thank you thank you.  I prefer using the solution Justin provided because if I ever needed to add another ID number, I'd just need to modify that query.

Thank...