July 10, 2018 at 7:31 am
dva2007 - Tuesday, July 10, 2018 6:55 AMAfter reading the article above I used dbo.DigitsOnlyEE which is very quick.
Exactly. That's why I wanted to see what you were using. Thank you for taking the time on the feedback here.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 10, 2018 at 7:47 am
No problem. Thank you to all who took time out to respond.
March 14, 2021 at 6:28 am
DECLARE @EMAIL AS VARCHAR(100)='support_dso104@itradeerp.com'
DECLARE @NUMBERS AS VARCHAR(100)='',@ALPHA AS VARCHAR(100)='',@SPECIAL AS VARCHAR(100)=''
;WITH TREE AS
(
SELECT SUBSTRING(@EMAIL,1,1) AS CHR, CAST(1 AS INT) AS LVL
UNION ALL
SELECT SUBSTRING(@EMAIL,LVL+1,1) AS CHR, CAST(LVL+1 AS INT) AS LVL FROM TREE WHERE LEN(@EMAIL)>LVL
)
SELECT @NUMBERS=COALESCE(@NUMBERS + '', '')+ IIF(CHR LIKE '%[0-9]%', CHR, ''),@ALPHA=COALESCE(@ALPHA + '', '')+ IIF(CHR LIKE '%[a-zA-Z]%', CHR, ''),@SPECIAL=COALESCE(@SPECIAL + '', '')+ IIF(CHR NOT LIKE '%[a-zA-Z0-9]%', CHR, '') FROM TREE
SELECT @NUMBERS AS Num,@ALPHA AS Alph,@SPECIAL AS Spl
Viewing 3 posts - 31 through 33 (of 33 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy