tag:blogger.com,1999:blog-1937347769359951209.post6759205813540753509..comments2024-03-29T03:20:30.513-07:00Comments on Microsoft Business Intelligence (Data Tools): SQL - Remove non-numeric characters from a stringMukesh Singhhttp://www.blogger.com/profile/10793266909993773163noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-1937347769359951209.post-90718549679586044402019-12-15T03:19:24.841-08:002019-12-15T03:19:24.841-08:00Numerology has been used for over 10,000 years to ...Numerology has been used for over 10,000 years to accurately reveal the secrets of love, wealth, success and happiness that lie hidden in your inner-self. <a href="https://www.meaningofnumerology.com/angel-number-444.html" rel="nofollow">444 in numerology</a><br />Lewishttps://www.blogger.com/profile/09001152979693960229noreply@blogger.comtag:blogger.com,1999:blog-1937347769359951209.post-66396922959938584762019-10-31T10:29:41.904-07:002019-10-31T10:29:41.904-07:00The Numerology predictions not only help in throwi...The Numerology predictions not only help in throwing an insight on a person's personality and life, but also on his/her health, career and married life. It also suggests remedies to improve the native's potential to succeed in life, by suggesting lucky numbers, lucky colours, lucky days etc.<a href="https://numerologyline.com/numerology-meaning/" rel="nofollow">numerology meaning</a><br />Lewishttps://www.blogger.com/profile/09001152979693960229noreply@blogger.comtag:blogger.com,1999:blog-1937347769359951209.post-21703868594166336022016-06-14T23:00:27.853-07:002016-06-14T23:00:27.853-07:00It can be achieved with less code using PATINDEX. ...It can be achieved with less code using PATINDEX. REfer below post<br /><br />http://www.itdeveloperzone.com/2012/01/get-numeric-value-from-string-in-sql.htmlSandeep Mittalhttps://www.blogger.com/profile/02880471130771695348noreply@blogger.comtag:blogger.com,1999:blog-1937347769359951209.post-65315225342957635492016-01-14T19:44:40.335-08:002016-01-14T19:44:40.335-08:00Thank Octavio. It's correct.Thank Octavio. It's correct.Mukesh Singhhttps://www.blogger.com/profile/10793266909993773163noreply@blogger.comtag:blogger.com,1999:blog-1937347769359951209.post-59377867373492391492016-01-13T14:08:26.350-08:002016-01-13T14:08:26.350-08:00Another idea
declare @a varchar(120) , @b varcha...Another idea<br /><br /><br />declare @a varchar(120) , @b varchar(120) , @car char(1) = '.'<br />Select @a ='octavio123Licea' , @b = @a<br /><br />while @car <> '' begin<br /> set @car = substring(@a , patindex('%[0-9]%',@a), 1)<br /> set @a = replace (@a , @Car,'') <br />end<br />set @car = '.'<br />while @car <> '' begin<br /> set @car = substring(@b , patindex('%[A-z]%',@b), 1)<br /> set @b = replace (@b , @Car,'') <br />end<br />select @a as Str , @b as 'int'<br /><br />:)Anonymoushttps://www.blogger.com/profile/15888016726346107569noreply@blogger.comtag:blogger.com,1999:blog-1937347769359951209.post-56733604864112502392016-01-13T14:06:04.350-08:002016-01-13T14:06:04.350-08:00This comment has been removed by the author.Anonymoushttps://www.blogger.com/profile/15888016726346107569noreply@blogger.com