Re: Informix SQL query on INTEGER column

I don't know if this will be of any help, but if you can convert your number to a string, you can use the built in substring functions, e.g. select data [1,3] Perhaps you could use a temporary table, with strings instead of integers. . . Michael m23443@mwvm.mitre.org