help required

Question

Viewing 5 posts - 1 through 5 (of 5 total)

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

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 1

You can make use of STUFF !

Is the dashes needed at the 4th and 8th places always ?

faruk.arshad SSC Veteran Points: 262 More actions · Answer 2

SSC Veteran

Points: 262

August 26, 2011 at 12:48 am

YES

ColdCoffee SSC-Dedicated Points: 39972 More actions · Answer 3

Something like this?

declare @String VARCHAR(15)= '12345676'

select @String = STUFF(STUFF(@String,4,0,'-') ,9,0,'-')

select @String

faruk.arshad SSC Veteran Points: 262 More actions · Answer 4

SSC Veteran

Points: 262

August 26, 2011 at 4:09 am

thanx its working 🙂