remove non-printing chars - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

remove non-printing chars

Author

Topic

darkdusky
Aged Yak Warrior

591 Posts

Posted - 2008-12-16 : 07:34:09

I need to remove non-printing characters from a field. This was a Server.HtmlDecode(" ") i.e. a space inserted from webpage (used for formatting dropdownlist. I tried parsing on webpage - but was unable ( I used: substring(), replace(),split(), and custom function).
So now trying to remove in insertion stored procedure.

If I run
SELECT [field] +'.',
ASCII(SUBSTRING([field], 4, 1))
.....

I get output:
"038 ." and "160"

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-16 : 07:35:35

just try REPLACE(field,CHAR(160),'')