the comments must go on a new comment field in a table like this

newID, priorID, firstname, lastname, date, comment

So the priorID is the ID from the comments table

ID, COM1, COM2

1,...

Sure:

at ufnHEXtoSID after this:

set @res = substring(@hexNumbBIN, @step,1)

select @AuxChar = dbo.BINtoASCIItoHEX(ascii(@res))

set @auxchar = isnull(@auxchar, '')

add this:

if len(@auxchar)= 1

set @auxchar = '0' + @auxchar

Regards

Well it looks like my post didn't catch a lot of interest as i thought... so i kept working, and fixed the script, now it seems to be working with...

Well i'm thinking right now... how come no one answered this one?

maybe it was too simple or too complicated or i just didn't posted it right. Any way. i've been...

Depending on your HD capacity, you might create a new table with the same column sctructure and with the proper indexes you want. And execute

Insert into [newtable] select * from...