< fkrauthan> `CASE WHEN TO NUMBER REGEXP REPLACE tranid ^0 9 NetSuite Professionals #suitescript

<@U9U62UJMD> `CASE WHEN TO_NUMBER(REGEXP_REPLACE({...

michoel

05/29/2018, 11:37 PM

@fkrauthan

CASE WHEN TO_NUMBER(REGEXP_REPLACE({tranid}, '[^0-9]', '')) > 1000 THEN 1 ELSE 0 END

4 Views