want funstion

Question

want funstion

Viewing 2 posts - 16 through 16 (of 16 total)

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

And looking again, you aren't a newbie, so you really have no excuse for not providing us with what we needed to help you.

As of today for you: Points: 1,170, Visits: 748

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 2

SUPER SQL STAR (3/16/2011)
hi,
i have data like
1234.45.1.46.678.1
i want a function which return when I Passesd 1 it will return the 1234
2 it will return the 45
3 it will return the 1
4 it will return the 46
-------
7 it will return null
what is procedure use char index in this function

The reason why so many of the folks want to know how you would use such a function before they provide an answer is so that they can give you the best solution. For example, rather than just returning one value, it may be better to return all the values in a sort of numbered list especially where performance of code may be concerned.

A lot of folks have asked for what they thought they wanted only to find out that an alternative solution to the problem worked out much better for them.

--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)