Sunday, March 25, 2012

Converting a value

I have a select statement like this:

select IsVerified from AppForm

the IsVerified returns 'True' ...can I convert that value to 'Yes' by using some sort of function?

SELECT IsVerified=CASE WHEN True THEN 'Yes' ELSE 'No' END from AppForm|||excellent, thanks!

No comments:

Post a Comment