Viewing 15 posts - 1,111 through 1,125 (of 1,251 total)
milos.radivojevic (4/8/2014)
BWFC (4/8/2014)
That solution works but will give an error if the string consists of only numerals.
Thank you BWFC for the correction!
A great thing in this forum is whenever...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
April 8, 2014 at 8:00 am
That solution works but will give an error if the string consists of only numerals.
declare @rowstring as varchar(max) = '1251596483'
select
case
when isnumeric(@rowstring) = 1 then @rowstring
else
REVERSE(
SUBSTRING(REVERSE(@rowstring),PATINDEX('%[0-9]%',
REVERSE(@rowstring)),PATINDEX('%[^0-9]%',
SUBSTRING(REVERSE(@rowstring),(PATINDEX('%[0-9]%', REVERSE(@rowstring))),LEN(@rowstring)))-1))
end
That will...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
April 8, 2014 at 5:58 am
Bells
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
April 8, 2014 at 1:01 am
Ed Wagner (4/7/2014)
TomThomson (4/4/2014)
Revenant (4/4/2014)
SQLRNNR (4/4/2014)
mishkaGrishka
Shishka
Bob
Shilling
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
April 7, 2014 at 5:22 am
Kurt W. Zimmerman (4/3/2014)
SQLRNNR (4/3/2014)
Ed Wagner (4/3/2014)
crookj (4/3/2014)
Revenant (4/3/2014)
Ed Wagner (4/3/2014)
JAZZ Master (4/3/2014)
SQLRNNR (4/3/2014)
rigoloLaugh
Cry
Baby
Girl
Daddy
Mommy
matriarch
Patriarch
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
April 4, 2014 at 1:26 am
Ed Wagner (4/1/2014)
TomThomson (4/1/2014)
crookj (4/1/2014)
Ed Wagner (4/1/2014)
SQLRNNR (4/1/2014)
breadDough
Won
Lost
Dog
Day
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
April 2, 2014 at 1:37 am
http://www.bbc.co.uk/news/technology-26822315
It seems to be a theme
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
April 1, 2014 at 4:04 am
Kurt W. Zimmerman (3/31/2014)
knucklehead
Drummer Caveman
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
March 31, 2014 at 9:01 am
TomThomson (3/28/2014)
Kurt W. Zimmerman (3/28/2014)
MicroScope
Scale
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
March 31, 2014 at 1:17 am
It's possible that he is in the wrong context, but we'll assume based on the intro that he is in the correct place.
I'm admittedly a bit of a newbie...
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
March 26, 2014 at 4:58 am
Eric M Russell (3/25/2014)
JudithK (3/25/2014)
Revenant (3/25/2014)
SQLRNNR (3/25/2014)
DoveTail
joint
Creame
Egg
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
March 26, 2014 at 2:03 am
Comprehension
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
March 25, 2014 at 2:38 am
Lonely
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
March 24, 2014 at 4:39 am
Revenant (3/23/2014)
TomThomson (3/23/2014)
Ed Wagner (3/21/2014)
BWFC (3/21/2014)
crookj (3/21/2014)
EricEyster (3/21/2014)
Ed Wagner (3/21/2014)
BWFC (3/21/2014)
WhoPinball
Wizard
Prestidigitator
Sleight
Hand
Pass
Mountain
Goat
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
March 24, 2014 at 2:36 am
crookj (3/21/2014)
EricEyster (3/21/2014)
Ed Wagner (3/21/2014)
BWFC (3/21/2014)
WhoPinball
Wizard
Prestidigitator
Sleight
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
March 21, 2014 at 9:07 am
Viewing 15 posts - 1,111 through 1,125 (of 1,251 total)