Since your codes are unique, you should be able to do a loop. 

Delcare the variables @CurrentID, @MaxID, @NewID

SELECT @CurrentID = (SELECT MIN( ID) FROM Table)

SELECT @MaxID = (SELECT MAX(...

aaaaaaarrrrggggghhh!  Everything I just wrote got lost. 

First, Kenneth, thanks for the extra work on my behalf.  All I meant was, I did go through BOL and found float to be a...

Thanks Kenneth.  I did read about it on BOL.  It is very imprecise and I simply do not see any application that it would serve.  Even if 3^rd part apps...

It took me a bit since I had other stuff to attend to in the mean time. 

This is what I have developed so far.  It is needed because the...

MY GOOF!  I had the wrong numbers in the SUBSTRING. 

This will work: 

SELECT CONVERT( datetime, SUBSTRING( '13071961', 3, 2) + '/' + SUBSTRING( '13071961', 1, 2) + '/' +...

Will your data always be in that format?  If so, you have a number of options.  Because I am American, I would prefer the following:  13071961 would be the value. ...

That was my point for posting this.  Look at CHAR(180) in this chart and then try selecting it from your query analyzer.  I bet you see a different result....  

I built a function to handle this with Invoice Numbers for an accounting contact I had, so I fully understand. 

But, I think in this case, one REPLACE looping through the...

Oh this is infuriating - I lost everything I just wrote!! 

First, this will never be used on a table, hence that is not...

I don't think I need to; albiet I now am adding another ID field to the table. 

DECLARE @Variable varchar(1),

 @TestScript varchar(25)

SELECT @Variable = 'I'

SELECT @TestScript = 'I...

I appreciate your confidence in me, but I think it may be misplaced.   

Could you offer an idea of how to make that...

I think I have it.  I am going to create a table named something like "SpecialCharacters".  It will have two fields, one for the character and a second for a...

This is a good discussion.  I have consulted for many years and many kinds of companies and invariably there is fight between Development and the DBA's.  (I have been in...

Just to throw a monkey wrench in the mix (I like argumentation who would'a guessed); what about this situation with respect to Social Security...

You should find many, many examples of Error Handling on this site.  You just need to remember to create a @Variable to capture @@Error, because you will immediately loose it...