Thanks Thomas. I will try out. On 22-Jul-2015 6:24 am, "Thomas D'Silva" <tdsi...@salesforce.com> wrote:
> The default regex functions just use Java Pattern > > > On Tue, Jul 21, 2015 at 2:28 AM, Ns G <nsgns...@gmail.com> wrote: > > Hi All, > > > > I have a requirement for using Regular expression. I am trying below > query > > but it doesnt seem to work. > > > > SELECT el_id from element where el_name like > > REGEXP_SUBSTR(el_name,'^[Z][A-Za-z0-9 \.]*') > > > > I dont know if this is correct usage or not. If you can point me any > source > > where i can get it will be helpful. > > > > Thanks, > > >