OSEC

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

From: Richard F. Rebel (rrebelwhenu.com)
Date: Mon Oct 03 2005 - 11:48:23 CDT


Hello,

How do you match all rows with a binary null (octal 000) in a given
column.

I have tried all sorts of strange combinations of REGEXP and LIKE with
no results. I have dug in the manual, but can't seem to find anything.

Any help would be appreciated.

--
Richard F. Rebel

cat /dev/null > `tty`

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

iD8DBQBDQWDXx1ZaISfnBu0RAoXyAJ9savOLP26YQ/X+TW0Ql8yQqRWkDQCfbRvg
SKu76JoGAb5oZsEvxV9oDc0=
=aZsS
-----END PGP SIGNATURE-----