Out of curiosity how do I use CHARINDEX if it can come back null? For instance if there is no CHAR(13) in the field?

Ok cool I will definitely be looking into that code later on to better understand and speed up what I am doing! Really appreciate it guys! Thanks.

Yes it does. What is the purpose of having a table with 10000 integers in it?

Thanks you for a quick response. I do have a few questions though. Is this just adjusting a table with new fields or is it creating a new...