Advance sql query for find numeric employeeid

[priyag]

Hi all ,
I need to find numeric employee ID in technical rule facing error ,while executing the advanced SQL query in technical rule showing invalid condition but successfully executed on SQL builder. Could you please help me on this.
select empid from users where empid REGEXP '^[0-9]+$'; -----> executed in SQL builder

[Manu269]

I doubt you can use regex.

[priyag]

can ypu pls provide regex syntax

[rushikeshvartak]

a.statuskey = 1 and a.employeeid is not null and a.employeeid !='' and LENGTH(a.employeeid) = LENGTH(TRIM(a.employeeid)) and LENGTH(a.employeeid) = LENGTH(REPLACE(a.employeeid, '0', '')) + LENGTH(REPLACE(a.employeeid, '1', '')) + LENGTH(REPLACE(a.employeeid, '2', '')) + LENGTH(REPLACE(a.employeeid, '3', '')) + LENGTH(REPLACE(a.employeeid, '4', '')) + LENGTH(REPLACE(a.employeeid, '5', '')) + LENGTH(REPLACE(a.employeeid, '6', '')) + LENGTH(REPLACE(a.employeeid, '7', '')) + LENGTH(REPLACE(a.employeeid, '8', '')) + LENGTH(REPLACE(a.employeeid, '9', ''))