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

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.