sql query need help

Question

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

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

Phil Parkin SSC Guru Points: 246993 More actions · Answer 1

There is no out of the box way to do this.

Have a look here for some ideas.

If you have only a few numbers to consider, there may be a simpler way to do it.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Koen Verbeeck SSC Guru Points: 259125 More actions · Answer 2

Add a few extra REPLACE?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

riteshk123 SSC Eights! Points: 820 More actions · Answer 3

If you have limited numbers add REPLACE or else create a user function.

Koen Verbeeck SSC Guru Points: 259125 More actions · Answer 4

riteshk123 (10/10/2014)
... or else create a user function.

That's kind of vague advice.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP