DesNorton
SSC-Insane
Points: 24619
More actions
July 14, 2017 at 12:14 am
#1950872
With not much to go on, this should get you startedDECLARE @String VARCHAR(20) = 'david,kam';
DECLARE @String VARCHAR(20) = 'david,kam';
SELECT RIGHT(@String, LEN(@String) - CHARINDEX(',', @String)) + ' ' + LEFT(@String, CHARINDEX(',', @string) -1);
coool_sweet
SSCommitted
Points: 1892
July 15, 2017 at 6:27 am
#1951034
thank you.it works
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply