SQL auto increment range or exclude numbers
<p>I am trying to add a range or exclude numbers from an auto increment column in sql.</p>

<p>We have an auto increment column regarding Job Numbers since each Job is unique. The problem is we treat ourselves as a client as well, and the job number as 99999 where as the other job numbers end for example 10500. When the auto increment takes place, it follows on from 99999. This there a way to exclude this or do I have to manual set the IDENTITY_INSERT ON and insert the ID myself? </p>

<p>Thanks in advance</p>