Tuesday, December 6, 2011

Case Statement in Sql Server

We can use CASE expression in the SELECT list, WHERE clauses, HAVING clauses, IN lists, DELETE and UPDATE statements, and even inside of built-in functions.

A Simple Example :
select case due_amt when 0 then 'Paid' else due_amt end as FeeStatus from dbo.tbl_feeinfo

No comments:

Post a Comment