Excellent, this seems to do the trick..... just need to know the main version.
DECLARE @outvar varchar(8000)
EXECUTE master..xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\NET Framework Setup\NDP\v2.0.50727','Version',@outvar OUTPUT
PRINT @outvar
Thanks