Click here to Skip to main content
13,086,662 members (55,942 online)
Rate this:
Please Sign up or sign in to vote.
See more:
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

thanks in advance,
Posted 30-Jan-13 2:29am

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.170813.1 | Last Updated 30 Jan 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100