Afficher un message
Vieux 14/02/2008, 04h31   #2
Michael Austin
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut 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??
  Réponse avec citation
 
Page generated in 0,05067 seconds with 9 queries