How to select a computed column

Question

I have a view from which I am selecting three columns. Of these three columns, one of them contains the OS version.

I want to create an additional column in the result which checks the OS Version. If the OS Version is less than 5.1 it should return 'Bad', if it is greater than that it should return 'Good'.

Any ideas about how to add this additional column?

Answer 1

Try this...

Select
    Col1,
    Col2,
    OS,
    OSResult = Case When OS < 5.1 Then 'Bad' Else 'Good' End
From
    Table

Answer 2

Assuming the column cannot be NULL:

SELECT  ...
        CASE WHEN OS_VERSION < '5.1' THEN 'BAD' ELSE 'GOOD' END AS IsVersionGood
FROM    ...

Answer 3

Hi,

select OS_Version, case when OS_Version <= 5.1 then 'Bad' else 'Good' end
from ...

Hope this can help.

Answer 4

You could also add it as a computed column to the table definition if you wanted e.g

ALTER TABLE dbo.OS ADD
    VersionOk  AS (case when [OS]<(5.1) then 'bad' else 'good' end)