<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>myOffice Email Message</TITLE>
<META content="text/html; charset=iso-8859-1" http-equiv=content-type>
<META name=date content=2002-11-01>
<STYLE type=text/css></STYLE>
<META name=GENERATOR content="MSHTML 8.00.6001.18882"></HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT color=#000000 size=2 face=Arial>An aside - but to avoid date locale
problems which I read about here before I ever did SQL I have always tended to
use</FONT></DIV>
<DIV><FONT color=#000000 size=2 face=Arial></FONT> </DIV>
<DIV>
<P><SPAN style="COLOR: #000000"><SPAN style="FONT-FAMILY: MS Sans Serif"><SPAN
style="FONT-SIZE: 10pt">where ( END>='2010-02-22' and END <=
'2010-02-26' )</SPAN></SPAN></SPAN> </P>
<P><FONT color=#000000 size=2 face="MS Sans Serif">instead of</FONT></P></DIV>
<DIV>
<P><SPAN style="COLOR: #000000"><SPAN style="FONT-FAMILY: MS Sans Serif"><SPAN
style="FONT-SIZE: 10pt">where ( END>=#22 FEB 2010 00.00.00# and END <=#26
FEB 2010 00.00.00# )</SPAN></SPAN></SPAN> </P>
<P><FONT color=#000000 size=2 face=Arial>but in practice I would have passed a
parameter as a datetime to avoid such issues...</FONT></P></DIV>
<DIV>John</DIV></BODY></HTML>