Mr. Ballantyne, you are right of course, I do need more training, but please do not impugn my intelligence by suggesting I am currently not going through tutorials or looking...

I've had a go and got something like this:

DESCLARE @FromDate VARCHAR(20), @ToDate VARCHAR(20);

SELECT *

FROM Table

WHERE Date BETWEEN CONVERT(DateTime, @FromDate, 103)

AND CONVERT(DateTime, @ToDate, 103)

This runs but it returns no data,...

Thank you very much for your help, I will try that out. Again thanks for the help and for replying so quickly as well.

Yes thank you, something like that. However when I do this:

Sample_date BETWEEN '01/06/09 00:00:00' AND '30/06/09 23:59:59'

I get this as an error message

"The conversion of char data type to...