eher so:
(von BETWEEN 13.11.2005 00:00:00 AND 18.11.2005 23:59:59) AND
((CONVERT (char, DATEPART(hh, von)) + CONVERT (char, DATEPART(n,von)) > '06:00') AND (CONVERT (char, DATEPART(hh, von)) + CONVERT (char, DATEPART(n,von)) < '12:30'))
eher so:
(von BETWEEN 13.11.2005 00:00:00 AND 18.11.2005 23:59:59) AND
((CONVERT (char, DATEPART(hh, von)) + CONVERT (char, DATEPART(n,von)) > '06:00') AND (CONVERT (char, DATEPART(hh, von)) + CONVERT (char, DATEPART(n,von)) < '12:30'))