Home Forums SQL Server 2008 SQL Server Newbies Creating a Ref Number usning letters and numbers. RE: Creating a Ref Number usning letters and numbers.

  • February 20, 2013 at 5:59 am

    #1589518

    Is booking number varchar(30) in the DB?

    If not look at computed columns and stick an extra column on the end of the table with the formula given to convert it to B00000000 etc