>BinToC() is exactly the function VFP internally uses to create sortable 4-byte combinations for integer keys. It actually adds a 0x7fffffff to the number, so the negative numbers don't appear greater than positive. Using BinToC() simply changes your data type from integer into character, but it's still the same four bytes which VFP uses in both cases. Though, having them represented as characters does allow for concatenation, which is quite handy. I already have some tables where I have a PK constructed as BinToC(FKey)+BinToC(LocalKey) and such.
Hi Dragan,
Good to see you.
That's not exactly the way BINTOC() works. It first does and exclusive OR on the most significant bit which is the sign. Positive numbers have it set, negative have it cleared. It then inverts the order of the bytes. Normally this is stored low byte to high byte. BINTOC() uses high byte to low byte.
George
Ubi caritas et amor, deus ibi est