why does not aField like '[0-9][0-9]%' work?

Analytics
N/A

why does not aField like '[0-9][0-9]%' work?

Is not the usage of [] in like pattern supported in TeraData?
1 REPLY

Re: why does not aField like '[0-9][0-9]%' work?

The only patterns available in like-expressions are % and _

% matches same as .* (a sequence of chars)
_ matches same as . (a single char)