Finding non-printing characters in data

[Laurie Gustin]

HP-UX 11.0
IDS 9.21.HC4


Just wondering if there is a simple way to find non-printing characters
embedded in char fields.
I have tried to match on the hex characters but it is actually a
substring that I am looking for.
Is there a function to convert HEX back to character???

What I need is something like this (except this doesn't work...)

table1
( field1 char(10),
field2 char(100)
);


Select field1, field2
from table1
where field2 like (some Hex value);


I know I am way off. Any help would be appreciated.

THANKS!



Laurie Gustin
Utah Department of Public Safety
801-965-4410
[email]lgustin@utah.gov[/email]
sending to informix-list

[Art S. Kagel]

On Tue, 29 Jul 2003 11:23:01 -0400, Laurie Gustin wrote:

The best way is to use a host language (like ESQL/C) and fetch the
strings into FIXCHAR type host variable and scan for non-printables in
the host language.

Art S. Kagel

> HP-UX 11.0
> IDS 9.21.HC4
>
>
> Just wondering if there is a simple way to find non-printing characters
> embedded in char fields.
> I have tried to match on the hex characters but it is actually a
> substring that I am looking for.
> Is there a function to convert HEX back to character???
>
> What I need is something like this (except this doesn't work...)
>
> table1
> ( field1 char(10),
> field2 char(100)
> );
>
>
> Select field1, field2
> from table1
> where field2 like (some Hex value);
>
>
> I know I am way off. Any help would be appreciated.
>
> THANKS!
>
>
>
> Laurie Gustin
> Utah Department of Public Safety
> 801-965-4410
> [email]lgustin@utah.gov[/email]
> sending to informix-list