Hi,
Is there any method or Built-In function which would help me to find the ASCII code of a Character or of a String(First character) in my SP.
I would appreciate if some one would give me the solution or point to where the solution can be found.

Thank's in Advance,
Ravinandan

Look in the SQL manual for the function ASCII.

Andy

Try the
ASCII()
function.

Thanks for quick response...

The ASCII() function worked....but strangely it is not present in the SQL manual.
The SQL manual from IBM site for DB2 Universal Database for iSeries SQL Reference V5R4(The database i'm using) doesn't have ASCII function in it's Built-In function's list.

Thanks once again.

You can also cast the data as varchar (or char) for bit data.

SELECT SEX, CAST(SEX AS CHAR FOR BIT DATA) FROM EMPLOYEE FETCH FIRST 1 ROW ONLY

SEX 2
--- -----
F x'46'

You can also use SUBSTR to isolate a particular character in the string.