Using REGEXP in PS Query criteria
edited Nov 18, 2023 5:10PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 4 commentsAnswered ✓
PeopleSoft 9.2 PT 8.59.13 Oracle Database 19c v19.20
I have a sql statement that executes successfully when I run it using
select * from PS_TL_GROUP_TBL a where REGEXP_LIKE(a.TL_GROUP_ID,'^[[:digit:]]+$');
I am trying to do similar in PS Query so i created an expression but I don't need to use it as a field but just use it as criteria but I get bad syntax errors like missing right parenthesis.
invalid operator when I attempt to change the criteria to a.tl_group_id = REGEXP_LIKE(a.TL_GROUP_ID,'^[[:digit:]]+$')
What is the best way to query for numeric values only in a character field in PS Query?
Tagged:
0