Is there a function that can work the same as NCHAR is SQL server or UNISTR in Oracle?
SELECT ('225'XC );
gives me "P but in sql server NCHAR (255) results in â.
Please suggest if there is a function or UDF for this purpose.
The CHR function works for numeric value input up to 255. The examples display the result in hex with char2hexint:
For Unicode values, a Unicode delimited identifier can be used:
BTEQ -- Enter your SQL request or BTEQ command:
sel char2hexint(U&'#00FF' uescape '#');