[SQL] Checking if date is inside date range

Hy list, I would like to check if date is inside a given date range. For instance if date range is datestart column: 10/10/2005 dateend column: 10/20/2005 I would like to return columns for date = 10/15/2005 and not if i enter let's say date = 10/21/2005 thanks for your help, Jure Kodzoman

Re: [SQL] Checking if date is inside date range

> I would like to check if date is inside a given date range. stupid question :) sorry for bothering you. Jure > ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster