Re: COUNT (*)

The way I do it (SCO UNIX, Informix 4.10) is to pipe the script output through "grep" to get rid of unwanted lines, e.g. z=`isql c2000 -qr t 2> /dev/null | grep -v count | grep .`; echo $z notes: 1 enclosing the sql in `` will (using SCO) put the result the variable on the left 2 "2> /dev/null" will throw away standard error, whch contains the "retrieved" line 3 "grep -v" will get rid of the "count" line 4 "grep ." will get rid of blank lines have fun Steve Edward Bidinotto <edbid@cobe.com> wrote in article <347B1FBC.6D29@cobe.com>... > To all" > > When you select count (*) > > isql dbname <<! > 1 row(s) retrieved. > > Is there any way to eliminate the 1 row retrieved within a script?