SELECT SUBSTRING(d.Age, 1, CASE CHARINDEX(' ', d.Age)
        WHEN 0
            THEN LEN(d.Age)
        ELSE CHARINDEX(' ', d.Age) - 1
        END) AS Age,
        Sex,
        SUBSTRING(d.[Weight], 1, CASE CHARINDEX(' ', d.[Weight])
        WHEN 0
            THEN LEN(d.[Weight])
        ELSE CHARINDEX(' ', d.[Weight]) - 1
        END) AS [Weight],
        Country,
        d.Age
FROM DrugEvents d