Can you give an example of what you are looking for? I'm not sure what you mean by "constant character" and I have no clue about TO_CHAR.

>Sorry for such a novice question. Looking for a function to convert
>an alphanumeric string value to constant character value for searching
>similar to "TO_CHAR"