Wednesday, April 18, 2012

How to Write Case Statement in SQL


Select  StudentId,
case
when StudentExpiryDate<getdate() then
StudentName + ' [Expired]'
else
StudentName
end
StudentName from ms_survey_corporate where StudentId=2000

No comments:

Post a Comment