a month ago
Am trying to write a simple Table function that accepts 1 parameter as character with length 500 for dynamic filter using APPLY_FILTER
Script looks like below
table to be queried contains 2 lines
If I execute the table function with 25000 as input, I get the error below saying invalid number? The underlying data type of this column is character 10
Any ideas? thanks
Request clarification before answering.
Fixed by passing the values in single quote
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
75 | |
30 | |
9 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.