Thanks I'll give it a try. Out of office for a few days. I'll let you know how it goes

I tried the loop and it cleared out the whole field and not just the ascii characters. i wrote it into a function

CREATE FUNCTION [dbo].[ReplaceCharacters] ( @InputString varchar(4000) )...

Your example is way far from my knowledge of SQL. I am going to try to see if I can understand what you are doing.

I appreciate your help.

The AttLabel field will have multiple words in it.