I usually use a custom query to generate random numbers or alphanumeric values! What DB are you using?