Inserting a value in an ordered string

Question

Inserting a value in an ordered string

Viewing 5 posts - 16 through 21 (of 21 total)

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

Sergei Ely SSC Enthusiast Points: 172 More actions · Answer 1

Mark,

My apologies. When I ran your code I had declared the existing string parameter as char instead of varchar. The code works great!

Thanks again.

S Ely

Sergei Ely SSC Enthusiast Points: 172 More actions · Answer 2

Sorry for the name gaff Jeff,

I must be getting old ....

Cheers!

Sergei

ChiragNS One Orange Chip Points: 26137 More actions · Answer 3

Nice one Mark...

Rarely see someone outdo Jeff ....:)

"Keep Trying"

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 4

Sergei Ely (1/13/2009)
Sorry for the name gaff Jeff,
I must be getting old ....
Cheers!
Sergei

No problem, Sergei... that's the whole idea, isn't get? Get older? 😀

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Jeff Moden SSC Guru Points: 1004664 More actions · Answer 5

Chirag (1/13/2009)
Nice one Mark...
Rarely see someone outdo Jeff ....:)

... and Mark knocked this one out of the park! 🙂 Nicely done, Mark.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)