Thanx for the info, but this field is my primary key and will never be null
:)

On 4/10/06, Helen Borrie <helebor@...> wrote:
>
> At 11:47 PM 10/04/2006, you wrote:
> >So simple ^^
> >
> >Thanx a lot man, this did the trick:
> >
> >SELECT COUNT(DISTINCT N.CUPOM)
> >
> >Cause N.CUPOM is my primary key, and thats all that matters :)
>
> True; and DISTINCT never counts nulls.
>
> ./heLen
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
> ------------------------------
> YAHOO! GROUPS LINKS
>
>
> - Visit your group "firebird-support<http://groups.yahoo.com/group/firebird-support>"
> on the web.
>
> - To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com<firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> - Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------
>


[Non-text portions of this message have been removed]