You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ROQL numeric wildcard

Received Response
34
Views
1
Comments
edited Jun 8, 2022 12:01PM in General Technical Discussions 1 comment

Content

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!