Need help in using Regex in Cache DB SQL
Hi,
Could someone help me in identifying all characters in a column is whole number 0 or greater
CASE WHEN '123' %MATCHES '[0-9]*' then 'VALID' else 'INVALID' end
The above statement is finding only for first character.
Thanks