>>>Hi,
>>>
>>>Who knows a shorter unique result than SYS(2015) delivers?
>>
>>Hi Peter
>>
>>could you explain what those uniqueness is good for?
>>SYS(2015) is not very good uniqe (for example for temp files on a multiuser scenario its not fast enough, I had crashes for non unique filles)
>>
>>This is by the way it is created.
>
>A colleague needs it to prevent that two users simultaneously create a temporary file. But more important is that he has only 5 positions to store the unique part.
>
>My guess is that he can use the right five positions of sys(2015) and delete the temporary file after a while.
>
>He wants to know the algorithm behind sys(2015).


Hi,

Sys(2015) is derived from '0123456789ABC ~ Z' using the datetime(). A 5 position only, I guess for the reason as stated above the RIGHT(SYS(2015),5) will do, not effective unique but within the day it should work.

Groet,

Koen