CREATE TABLE #T(Cola VARCHAR(6),Colb CHAR(1)) INSERT INTO #T(Cola,colb) SELECT 'FGHIJK',LEFT('FGHIJK',1)-- check result SELECT Cola,colb FROM #TResult:Cola colbFGHIJK F