CREATE PROCEDURE myproc    
        @WBS1 varchar(30),
    @DescCategory varchar(10)

AS

declare @ptr binary(16) ,
    @i int ,
    @datalen int ,
    @DelPos int
    , @Char int

Declare MyCursor CURSOR for
select WBS1, DescCategory from mytable 
where WBS1 Like @WBS1
And DescCategory Like @DescCategory
AND PATINDEX('%[^a-zA-Z0-9]%',Description)<> 0
open MyCursor

FETCH NEXT FROM MyCursor into @WBS1, @DescCategory

WHILE @@FETCH_STATUS = 0
    BEGIN


select @i = 0
    , @datalen = datalength(Description) 
from mytable where 
    DescCategory = @DescCategory
    and WBS1 = @WBS1

while @i < @datalen
begin
    select @DelPos = @i
    select @i = @i + 1
    Select     @Char = ascii(substring(Description,@i,1))
    from     mytable
    where     WBS1 = @WBS1
        and DescCategory = @DescCategory

    if @Char < 32 or @Char = 255
        begin
            select     @ptr = textptr(Description)
            from mytable where
                DescCategory = @DescCategory
                and WBS1 = @WBS1
            updatetext 
            mytable.Description 
                    @ptr 
                    @DelPos
                    1 
                    ' '
        end
end
FETCH NEXT FROM MyCursor into @WBS1, @DescCategory
    END

CLOSE MyCursor
DEALLOCATE MyCursor

GO