• river1 (2/25/2010)


    when i do this command:

    select

    serverproperty ('productversion')

    if the first digit returned by the string is 8 then 2000

    if the first digit returned by the string is 9 then 2005

    ..........

    select case when cast(serverproperty ('productversion') as varchar(2)) like '8%' then '2000'

    when cast(serverproperty ('productversion') as varchar(2)) like '9%' then '2005'

    when cast(serverproperty ('productversion') as varchar(2)) like '10%' then '2008'

    end

    Converting oxygen into carbon dioxide, since 1955.