T-SQL for finding SQL Server Version

SELECT
    CAST(SERVERPROPERTY('ProductVersion') AS varchar(100)) + ' ' +
    CAST(SERVERPROPERTY('Edition') AS varchar(100)) + ' ' +
    CAST(SERVERPROPERTY('ProductLevel') AS varchar(100));