substring(PartName, 1, 20)
DECLARE @substringTable TABLE (MyText nvarchar(50))
INSERT INTO @substringTable (MyText)
VALUES ('12345678901234567890'), ('1234'), ('abcdefghijklmnopqrstuvwxyz')
SELECT SUBSTRING(MyText, 1, 8) FROM @substringTable
No comments:
Post a Comment