For MSSQL:
declare @str varchar(255)
declare @i int
set @str = ''
set @i = 32
while @i <= 127
begin
set @str = @str + '|' + char(@i)
set @i = @i + 1
end
SELECT * from s_qos_data
WHERE target LIKE '%[^' + @str + ']%' escape '|'
Other examples for the end of the query include:
SELECT * from nas_alarms
WHERE message LIKE '%[^' + @str + ']%' escape '|'
For Oracle:
SELECT qos,source,target
FROM s_qos_data,
TABLE((SELECT COLLECT(LEVEL)
FROM DUAL
CONNECT BY LEVEL <= LENGTH(target))) WHERE ASCII(SUBSTR(target, COLUMN_VALUE, 1)) > 127