Generating Numbers from Stored Data in Database

See more:

VB

Dears ,

I have millions of records in SQL Database which are upto 25 digits Numbers like Policy Numbers,Account Numbers etc...,I just want to generate 10 Digits Numbers for Every Records which is retrieving from the table.

Example :

Type < Data > < Unique ID>

Policy No<215-163202-1121521532> < Null>
A/C No < 612-9650-15264859632> < Null>
Ref No < 9635-5621452-2986597542 > < Null>
Contract No < 98652-365215-20123202323 > < Null>

I want to generate unique Numbers with prefix based on type of Data,Data might be 10 or 12 Digits Numbers

Please help me to generate in Vb.net

thanks in advance,