IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[remove_non_printable_characters]')
AND type in (N'FN', N'IF',N'TF', N'FS', N'FT'))
drop function [remove_non_printable_characters]
GO
Create function [remove_non_printable_characters] (@input_string nvarchar(max)) returns table with schemabinding as return ( select replace(replace(replace(replace(replace(replace(replace(replace(replace(replace( replace(replace(replace(replace(replace(replace(replace(replace(replace(replace( replace(replace(replace(replace(replace(replace(replace(replace(replace(replace( replace(replace(@input_string collate latin1_general_100_bin2, char(1), ''),char(2), ''),char(3), ''),char(4), ''),char(5), ''),char(6), ''),char(7), ''),char(8), ''),char(9), ''),char(10), ''), char(11), ''),char(12), ''),char(13), ''),char(14), ''),char(15), ''),char(16), ''),char(17), ''),char(18), ''),char(19), ''),char(20), ''), char(21), ''),char(22), ''),char(23), ''),char(24), ''),char(25), ''),char(26), ''),char(27), ''),char(28), ''),char(29), ''),char(30), ''), char(31), ''), char(0) , ' ') as clean_string )
go

SELECT  c1.clean_string,
 c2.clean_string,
* FROM qm0174_001_20181205 q cross apply remove_non_printable_characters(CAST(q.QM0174_KEY_NR AS VARCHAR(MAX))) c1
  cross apply remove_non_printable_characters(CAST(q.QM0174_SATZ AS VARCHAR(MAX))) c2
go