>Hi
>
>How to get the last 3 digits of a numeric fields, as below:
>
>
>39932 ...................932
>111115454.............454
>
>Or how to generate random numeric values under 1000
>
>939
>221
>014
>
>etc
>
>Moises
? RIGHT(TRANSFORM(NumericValue),3)
RAND(-1)
? (RAND()*100000000)%1000
(both not tested!)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.