Re: non-printable chars - difficult question
northof40 wrote:
> Hi - I want to select all rows where the string contained within a
> varchar column, C1, contains a character outside of the range x20 to
> x7E.
>
> So if, for instance, a copyright symbol (xA9) appeared within the
> string contained in C1 I want that row to be output.
>
> My charset is binary.
>
> Thanks for any ideas.
>
> Regards
>
> Richard.
>
Have you looked at the binary operator - possibly used with the cast
operator??
|