>Hi everybody,
>
>In the compound index I use BINTOC function to convert everything to string. So my index expression will look like:
>ccode+town+street+bintoc(stNum)+StNumExt... where stNum is Numeric 4. However, we found, that it sorts things incorrectly, e.g. 109 appears before 84. So, does it mean, what this function could not be used or I have some sort of data corruption...?
>
>Thanks in advance.
Are you sure ? If your stNums <= 0x7FFFFFFF then it'd sort right.
Cetin