Home Forums SQL Server 2008 T-SQL (SS2K8) how to remove characters char(0) to char(31) RE: how to remove characters char(0) to char(31)
Gazareth
One Orange Chip
Points: 27737
More actions
November 16, 2012 at 7:01 am
#1559796
I'd go with nested REPLACEs. It's not going to look nice but I don't think there's a better way.
Perhaps wrap it in a Function if you need to reuse or to keep code tidy?