Advanced sql query for find numeric employeeid

[priyag]

Hello All,
i need a help to find out the numeric employeeid here it is the condition and converted into advance sql query.

And( u.status == true, IsRegexMatch(u.Employee ID, "^\d+$") )

[rushikeshvartak]

Query is used where ?

[priyag]

technical rules

[rushikeshvartak]

u.statuskey=1 AND u.EmployeeID REGEXP '^[0-9]+$';

[priyag]

thank you but unfortunately not working . Is regexp supported in advance sql query

[priyag]

it's showing invalid condition

[rushikeshvartak · Accepted solution]

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', ''))

[priyag]

thank you so much rushikesh

[rushikeshvartak]

✅Please click the 'Accept As Solution' button on the reply (or replies) that best answered your original question and hit kudos👍