OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: How to match a binary null in a varchar column???

From: Richard F. Rebel (rrebelwhenu.com)
Date: Mon Oct 03 2005 - 16:12:57 CDT

Hi Keith,

Thanks, it did work.

I was trying to use a regular expression but this is just fine for my
needs.

On Mon, 2005-10-03 at 13:18 -0400, Keith Ivey wrote:
> Richard F. Rebel wrote:
>
> > do I say REGEXP BINARY "<what?>"
> >
> > I have tried \000 \0 as they are common representations for binary null.
>
> Have you tried "WHERE your_column LIKE '%\0%'"? That works for me.
>
> --
> Keith Ivey <keithsmokefreedc.org>
> Smokefree DC
> http://www.smokefreedc.org
> Washington, DC
>
--
Richard F. Rebel

cat /dev/null > `tty`

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQBDQZ7Zx1ZaISfnBu0RAl5MAJ9Yfk6WACmA2s7bc9VxjnOizdYKcwCcDMvy
FYqVj+FTTs6htdtY6WH/acE=
=T4Gg
-----END PGP SIGNATURE-----