generating random number

Question

i want to generate a random number which contain mmyy from date of birth,IND and and rest a random number....
my data is stored in database..i have to retrieve it from sqlserver..