Nick Upson wrote:

>
> 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.

This is just an 'OTTOMH'. Can you create a table with all the possible
values you want to compare with, using the ascii value of each char as
the index? Then, do scalar sub-select to return the value you want?


Paul
--

Paul Reeves
http://www.ibphoenix.com
taking InterBase further