Obrigado atravez de sua dica achei esta materia que me deu o que queria http://www.mssqltips.com/tip.asp?tip=1026 SELECT LEFT('Microsoft SQL Server', CHARINDEX(' ', 'Microsoft SQL Server - SQL Server',13) - 1) Microsoft SQL (find portion of string where a space is found but starting at position 13) SELECT LEFT('Microsoft SQL Server', CHARINDEX(' ', 'Microsoft SQL Server - SQL Server') - 1) Microsoft (find portion of string where a space is found) SELECT LTRIM(RTRIM(' Microsoft SQL Server - SQL Server ')) Microsoft SQL Server - SQL Server (trim leading and trailing spaces)