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.
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
Post a Comment