I tried having an external table that also contained the 'bad'
character and doing ' .. where not in (select bad ..)
but that didn't work either

>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: http://mobile.msn.com
>

_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com