Thanks for the look at this to all but I think i figure it out by reading the help and looking at examples thatnks again

DECLARE @TranNumber int
update control set @TranNumber=txnum=TranNumber+1
select @TranNumber as txnum

thanks again
Shawn