Auto generate a number

[chriswheat]

I want a field tkt_num to automaticly create a number

I know about set and auto incrament.

But I don't want 1 then 2 then 3 and so on

I want like a 5 digit number.

Many thanks
Chris

[Danicek]

What do you want - autoincrementing number with 5 digits or random number with 5 digits?

[chriswheat]

I would like a random number. If it is possible... If not I know to do the set and auto_incrament

Thanks
Chris