Hey!
I’m trying to apply a customer filter based a substring of a numeric id.
As I need to apply the ‘less than’ operator, I need both arguments to be numeric, allthough I can’t seem to convert the substring result to a number. ‘to_number’ and ‘cast’ functions are not working.
How can I fix this simple restriction?
Thanks in advance!
That’s because your ID is probably of type:number. Try the following: