reverse words in string

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

DesNorton SSC-Insane Points: 24386 More actions · Answer 1

With not much to go on, this should get you started
DECLARE @String VARCHAR(20) = 'david,kam';

SELECT RIGHT(@String, LEN(@String) - CHARINDEX(',', @String)) + ' ' + LEFT(@String, CHARINDEX(',', @string) -1);

How to post data/code on a forum to get the best help.

coool_sweet SSCommitted Points: 1892 More actions · Answer 2

SSCommitted

Points: 1892

July 15, 2017 at 6:27 am

thank you.it works