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