Searching Strings
-
Comments posted to this topic are about the item Searching Strings
-
Heh... NOT a bad question, Steve.
--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) -
Almost praise. I like it
-
Gosh... I hope you didn't take it the wrong way. It was meant as praise with the NOT referring to the critical symbol used in this great question.
--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) -
In the explanation, to be precise, I would change "where the first number is not a 9"
with "where the first char is not a 9"
-
Great question, but I had trouble with the wording of the correct answer. I'm not sure that's a grammatically correct sentence.
-
The answer should be: "strips all leading '9' from the input
This method is useful when dealing with prefixes like leading zero.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply