[AccessD] SQL between

Someone mentioned this to me yesterday...but it was about A2K2.  I tested on a number field and it WAS inclusive.  Is it related to dates?...or what are the circumstances?
 
Thanks,
 
Mark A. Matte
> From: john at winhaven.net> To: AccessD at databaseadvisors.com> Date: Fri, 26 Oct 2007 14:37:52 -0500> Subject: [AccessD] SQL between> > I have recently found a couple of issues in an app converted from A97 to> A2k3. The items of questions worked in A97 but fail in A2k3.> > Problem 2. )> > (Well, I guess this is more of a heads up.)> > SQL between is not inclusive. So now I have to do a between DATE1 -1 and> between DATE2 +1> > > > BTW I've always though it odd that it was inclusive but it seems to be many> of the SQL products but not in others. Standards!?> > > > -- > AccessD mailing list> AccessD at databaseadvisors.com> http://databaseadvisors.com/mailman/listinfo/accessd> Website: http://www.databaseadvisors.com
_________________________________________________________________
Climb to the top of the charts!  Play Star Shuffle:  the word scramble challenge with star power.
http://club.live.com/star_shuffle.aspx?icid=starshuffle_wlmailtextlink_oct