See if SQL doesn't have such a feature?

ga72x1

I will now process the variables passed in. The variables passed in are: string + number
But I want to take out the numbers, but the string digits are not fixed. Is there such a function in SQL that only takes numbers, for example, pass the parameter "AAA12" and only get 12? fixed

wgfxman

If there are no numbers in the string, it can be done
Can only write by myself, there is no ready-made

fanfan1980

declare @str varchar (100)
set @ str = 'AAA12'
select right (@str, len (@str) -patindex ('% [0-9]%', @str) +1)
--result
12

fanfan1980

declare @str varchar (100)
set @ str = 'AA12'
select stuff (@str, 1, patindex ('% [0-9]%', @str) -1, '')

wgfxman

declare @SQL_ALL CHAR (255)
declare @SQL_CHAR CHAR (255)
declare @SQL_INT CHAR (255)
declare @SQL_LEN INT
declare @INT_LEN INT

select @ SQL_ALL = 'AA121334A16552'
SELECT @ SQL_LEN = len (@SQL_ALL)
select @ INT_LEN = 1
while SUBSTRING (@ SQL_ALL, @ SQL_LEN- @ INT_LEN, 1) BETWEEN '1' AND '9'
    SELECT @ INT_LEN = @ INT_LEN + 1

SELECT RIGHT (RTRIM (@SQL_ALL), @ INT_LEN)

--------------
16552

wgfxman

1. There are no numbers in the middle of the string. It is relatively simple to follow thefanfan1980method.
2. If there may be digits in the middle of the string, judge from the right