ASCII Package
=============

Here is an SQL package that provides two functions - ASCII('a') which
returns the number corresponding to the first letter of the supplied
string, and CHR(97) which returns the character responding to the
supplied number (in the range 0..255, but be wary of 0).  The gzipped
tar file is tiny - 1918 bytes compressed.


If you have SQLCMD, then you can run "sqlcmd -d dbase -f mkascii.sql" to
create everything -- if you get fancy, you can make mkascii.sql
executable and edit the pathname to sqlcmd into it, and then run the
following command to create the information in a database called
mode_ansi.  It will work for logged, unlogged and mode ANSI databases.

    mkascii.sql mode_ansi

If you don't have SQLCMD, you can use DB-Access to create the ASCII
table (asciitbl.sql), and the procedures (ascii.sql, chr.sql) and then
load the ASCII table from ascii.unl.  There are 255 lines of data in
ascii.unl - the missing value is ASCII NUL.

Jonathan Leffler <jleffler@us.ibm.com>
2005-04-18