Code:
DECLARE @X NVARCHAR(MAX) = 'the cat went up the hill: the dog followed on behind the mouse went the other way' SELECT SUBSTRING(@X,0,8)+ SUBSTRING(@X,33,20)+ ': '+SUBSTRING(@X,55,9)
SimMed
Last Activity: Oct 30 '13, 05:41 PM
Joined: Oct 30 '13
Location:
-
Something like that?Last edited by Rabbit; Oct 30 '13, 05:47 PM. Reason: Please use [CODE] and [/CODE] tags when posting code or formatted data. -
@Rabbit is right, do you have these tables you are referring to?Leave a comment:
No activity results to display
Leave a comment: