<p>I am totally new to <code>SQL</code>. I have a simple select query similar to this:</p>

<pre><code>SELECT COUNT(col1) FROM table1
</code></pre>

<p>There are some 120 records in the table and shown on the <code>GUI</code>.
For some reason, this query always returns a number which is less than the actual count.</p>

<p>Can somebody please help me?</p>

Try
```
```
select count(*) from table1
```
```
Edit:
To explain further,
```
count(*)
```
gives you the rowcount for a table, including duplicates and nulls.
```
count(isnull(col1,0))
```
will do the same thing, but
slightly
slower, since
```
isnull
```
must be evaluated for each row.