ROQL numeric wildcard
Hi I need to be able to use a numeric wildcard in an Select statement that caters for multiple numeric characters not just a single character..
For example I need to search for all email addresses that start with 's' and have multiple numeric characters before the '@';. Say, s1234887@xxxxx
Using LIKE 's[0-9]%@xxxxx'; or similar returns zero records when there are records that exist.
For example: LIKE 's0%@xxxxx'; returns 69 records - however some of these have non-numeric characters before the @, such as s0898tt@xxxxx and we do not want these.
Is there REGEX capability here somewhere?