T-SQL Code: [...] SET @OGCWKT = (SELECT Geometry FROM inserted); SET @valuesOnly = LEFT(@OGCWKT,LEN(@OGCWKT)-1); SET @valuesOnly = RIGHT(@valuesOnly,LEN(@valuesOnly)-12); RAISERROR(N'@valuesOnly = %s',0,0,@valuesOnly); DECLARE @Index INT; SET @Index = (SELECT CHARINDEX(@valuesOnly,N',')); RAISERROR(N'charindex of , = %i',0,0,@Index); [...] Input: Geometry = 'LINESTRING (-1.21263269085502 53.1441705273226,-1.21261278851606 53.1441091569917)' Output: @valuesOnly = -1.21263269085502 53.1441705273226... read more
