Hassle-free live chat software re-imagined for business growth. 2 users, always free.
SELECT LEFT(subsrt, PATINDEX('%[^0-9]%', subsrt + 't') - 1) FROM ( SELECT subsrt = SUBSTRING([message], pos, LEN([message])) FROM ( SELECT [message], pos = PATINDEX('%[0-9]%', [message]) FROM Table ) d ) t
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!