Greetings,

I am cleaning up our databases for the inevitable move to MS SQL.

One thing I've encountered is that Suprtool does not like null characters where there should be numbers.

I know that I have invalid characters, (non-numeric), in a field called ITEM-NUMBER.  But when I try
to find those records, Suprtool chokes and abruptly stops the search.

Here's what I get...

>IF ITEM-NUMBER < 0 OR ITEM-NUMBER > 9999
>X

Error:  Illegal ascii digit encountered. Please check all data sources

Input record number: 1
>

Is there a way to run Suprtool to help it find these records?

Query finds them just fine, but Query doesn't have to ability to do what I want to do.

Thanks,

Ernie

________________________________

This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message.

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *