Sql streng

select count(*) from tabel where dato=\'07.04.01\'

Det kommer lidt an på databasen

SELECT count(*) FROM YourTable where TheField Like \"07.04.01%\"

Oh is that a date, I thought it was just one text field containing for example 07.04.01 86161039

If it is a date/time field then rmemebr that date formats should be in the U.S format which is MM-DD-YYYY. Not easy to see from your example!

rmemebr  = remember

Det er en Paradox database!

Jeg skal have antal ind i en variabel!

Det er tekst felter begge to!

That wasnt the original question, you wanted an SQL statement!

Kan du ikke bruge

select count(*) AS Resultat from tabel where dato=\'07.04.01\'
if(Resultat == 20)
  Saa bla bla bla
else
Noget andet bla bla bla

The SQL statement is thhe same for paradox I would think but not knowing anything about paradox I wouldnt know how to give you the result, that bits up to you!

så er det nok mere noget i retning af:
select count(*) AS Resultat from tabel where dato LIKE \'07.04.01\'

In access or VB
you would open a recordset to see the result, how thats done in Paradox I dont know!