Is Format Functions Avail in SQl Server?

• Saravanan_tvr

  SSCarpal Tunnel

  Points: 4558

  More actions

  January 25, 2011 at 7:32 am

  #230837

  Dear All,

  I have to create the auto Generation Number in sql like Identity but

  The Problem is

  The Data like the below format

  00001

  00002

  .

  .

  .

  .

  00010

  00011

  00012 Etc

  Is it possible? I know the INT,NUMERIC, will void the prefix zeros

  But is it possible to bring this format in result set?

• January 25, 2011 at 7:39 am

  This was removed by the editor as SPAM