slq语句 substring (firstname,1,3)+ substring (lastname,1,

DECLARE @firstname varchar(20),@lastname varchar(20),@Result varchar(20)SET @firstname='Michael' SET @lastname='Jordan'SET @Result =substring (@firstname,1,3)+ substring (@lastname,1,2)@Result =MicJo