declare @c nvarchar; declare @index bigint; select @c=FirstName,@index=CHARINDEX('<',FirstName,0) from Modell where Id=27; select SUBSTRING(FirstName,0,@index) from Modell where Id=27;