Sorry for the name gaff Jeff,

I must be getting old ....

Cheers!

Sergei

Mark,

My apologies. When I ran your code I had declared the existing string parameter as char instead of varchar. The code works great!

Thanks again.

S Ely

Mark,

Thanks for the input. The solution requires placement of the integer within the ordered string at variable positions. For example, the existing string could be a single integer ie...

John,

The code worked perfectly. 😀 Thanks again.

Sergei

Wow. I'll take a look at this over the weekend and let you know how it goes. Thanks again!

Sergei Ely

Your assumption about the numerical order is correct. The existence of a number in the field refers to a specific checkbox (of which there are 10)in the front end...

Thanks Jeff. I neglected to mention that the insert position is variable, though. The field is char(9) with the values restricted to integers 1-9 so the insertion could...