>>>>>Hi Tore
>>>>>
>>>>>Nice to see other than me online.
>>>>>
>>>>>Are you any good at SQL? cos I sent this message yesterday and I can't figure why my SQL was working fine but now just selects all, or many, operators
>>>>>
>>>>>Message #1141384
>>>>>
>>>>>I'd really appreciate any help, and I'm going round lately cap-in-hand, as I need to get this finished before tommorow of I don;'t go on holiday (all booked)
>>>>>
>>>>>Cheers
>>>>>
>>>>>Terry
>>>>
>>>>Is this "real" SQL or VFP SQL? If it's "real" SLQ, I have to pass, since I only have experience with VFP SQL.
>>>
>>>No VFP (7) SQL :-)
>>
>>Well, at least I see that the Between syntax in the Where clause is incorrect:

>>And (ET.date BETWEEN ldStartCurr and ldEndCurr ;
>>  OR ET.date BETWEEN ldStartPrev and ldEndPrev)

>>Should be something like

>> And (between(ET.date,ldStartCurr,ldEndCurr) ;
>>  OR between(ET.date,ldStartPrev,ldEndPrev))

>>What happens if ET.date is empty or NULL?
>
>No Tore,
>Sytax is Correct, in VFP SQL you could use -> somevalue BETWEEN Low AND high. I think VFPT made this just to be easy to switch to SQL Sever.

You learn something new every day....! :-)