>I hate @*#^@^&# integers :-)
>
>I used to use SYS(3), then went to SYS(2015) and now I'm quite happy generating GUIDs for primary keys

Craig's right about character vs Integer. The reason is basically that a character must be internally converted to integer when it is stored, and converted back when retreived. (as we know, machines don't store letters, they store numbers that represent characters)


>.....any system which relies on an incremented number, in VFP, is suspect >IMHO...now in SQL that's a different story.

Would you mind expanding on this?