sql server - SQL Padindex Second position numeric word -


i have below query when trying search second numeric word string didn't correct results.

select right('1111 test 2222 3333',               patindex('%[^0-9]%', '1111 test 2222 3333' +'.') - 1) 

results should be: 2222

i appreciate if 1 on this.


Comments