• That won't work. The identity property you can only declare on numeric columns like int, or decimal. Leading 0s will be ignored.

    What do you want this for?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]