To get back a part of text in MS SQL you might want to consider using Substring function.
Example:
SELECT SUBSTRING ([ContactName], 1,5) AS First5CharOfContactName
FROM [Northwind].[dbo].[Customers]
This will return you back first five characters in the filed ContactName.
The Syntax goes as:
SUBSTRING (expression, start, length )
ae9e6c6c-90cb-44bb-ac1b-f58d6ff3f1b3|0|.0