-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
On Wed, 29 Sep 2004, Kumar S wrote:
> How can I delete empty rows in a table that I have.
<snip>
> In this table columns 3,6,9 and 10 are completely
> empty. I tried
>
> =>DELETE from my_table where fc_huge_name = ' NULL';
DELETE FROM my_table WHERE fc_huge_name IS NULL;
will work I think.
Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
iD8DBQFBWulwtl86P3SPfQ4RAhx7AJ9GnQD/9zCbxKDESs3ye2OmAmCoaACaArzF
6JDwhKK4BwyMI9nSI6ez5Tk=
=zghJ
-----END PGP SIGNATURE-----