Subject identify a char
Author Nick Upson
can I express a char(1) field value in hex?

charfld = '\x00';

I'm currently importing a load of data via external tables, using a dbproc
to perform the actual conversion to the internal table(s) for each.

Unfortunately the data file has a load of null characters at
the end. I want to do something like "select ... from externaltable where
field <> ch" but I can't work out how to express the value for ch.

cat -v shows the character as ^@, my editor (pfe) shows it \x00

Send and receive Hotmail on your mobile device: