Hey y'all,
Can someone make this right? i have an int column and need text:
SELECT (SELECT CASE score WHEN 0 THEN 'qqqqqqqq' ELSE 1 END) AS Expr1, COUNT(Score) AS Expr1
Thanks in advance
SELECT CASE score when 0 then 'qqqqqqqq' ELSE '1' END AS Expr1, COUNT(Score) AS Expr2
Like that?
|||score is always 0,1 or 2 but i need written labels (text) for my charting...
i can do it with a selection in the build of my chart but i was wondering of i could do it in sql...
|||SELECT CAST(score as varchar(1)) As score,count(*)
?
