StaticPhoton

WITH VersionParts AS (
  SELECT *,
    CAST(PARSENAME(REPLACE(version, '.', '.'), 3) AS INT) AS major,
    CAST(PARSENAME(REPLACE(version, '.', '.'), 2) AS INT) AS minor,
    CAST(PARSENAME(REPLACE(version, '.', '.'), 1) AS INT) AS patch
  FROM your_table
)
SELECT *
FROM VersionParts
WHERE