SQLServerCentral / SQL Server 7,2000 / SQL Server CE / When appropriate to use CASE statement / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 10:32:08 GMT20When appropriate to use CASE statementhttp://www.sqlservercentral.com/Forums/Topic952327-137-1.aspxI am trying to create a statement that tells me if there is a payment pending record yesterday, but today there is not due to a cancelled payment. I figured out the codes - disregard positngWed, 14 Jul 2010 07:32:23 GMTjaclyn.c.may