POSITION operates on the following types of arguments:
- Character, except for CLOB
- Byte, except for BLOB
If one string expression is of type BYTE, then both expressions must be of type BYTE.
- Numeric
Numeric string expressions are converted implicitly to CHARACTER type.