easy to grab what you need; here's a better example:
select
parsename(convert(varchar,serverproperty ('productversion')),4) As T4,
parsename(convert(varchar,serverproperty ('productversion')),3) As T3,
parsename(convert(varchar,serverproperty ('productversion')),2) As T2,
parsename(convert(varchar,serverproperty ('productversion')),1) As T1
--results:
T4 T3 T2 T1
-- --- ----- ---
9 00 4035 00
Lowell