SELECT SUBSTR(ename,1,10) as Nimi, SAL as Palkka, SAL*0.1 AS Korotus, '=', SAL+SAL*0.1 As UusiPalkka FROM emp;
Transact-SQL: SUBSTRING