Portal

M regex to check if all the digits of phone are same is "^([0-9])\\1*$". But it is not working with regexp_like in semarchy. this regex is working in java plugin. my data location is sql server. i tried to check this regex in sql server using like operator. It is not working in sql server. currently i have used java plugin in my project.

Is there any possible way to use regex in semarchy where data location is sql server?

Regexp is not natively supported by SQL Server, therefore you won't be able to use regex functions if the Datasource for your Data Location is SQL Server.

Furthermore, in SQL Server REGEXP_LIKE  is equivalent to the LIKE operator.