Autonumber in text

[kenche0820]

I'm currently having a problem generating a unique ID because the field is text instead of number.

I tried using the max function in my query:
SELECT max(entityID) as maxID FROM Entity;

but it would return 9999 as the max even though there are other records with ID 10012, 10023, etc. Can I somehow alter my SQL statement to get the numeric maximum?

Thanks,

Kenneth

 

[zrzr]

did you try this ?

SELECT max(CDbl(entityID)) as maxID FROM Entity;

 

[kenche0820]

That did the trick. Thanks very much!