Re: multiple date params

From: Dennis Forbes (DennisForbes_at_discussions.microsoft.com)
Date: 09/28/04 

Date: Tue, 28 Sep 2004 13:33:03 -0700

Well there is a certain presumption that the original poster has a
rudimentary understanding of SQL, given that they apparently know how to use
BETWEEN for other data types. I was taking it as pseudo-code and not literal
code.

"Aaron [SQL Server MVP]" wrote:

> > Put apostrophes around those and you're good to go.
>
> Really?
>
> between ... and ...
> and between ... and ...
> and between ... and ...
>
> Apostrophes or not, it's malformed SQL.
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>

Relevant Pages

  • Re: SQL RPGLE cursor delete from view? -204
    ... Even if you could do the delete from the cursor, you wouldn't want to since as I read your post you simply want to remove a record from the current result set without affecting the actual data. ... a DELETE operation in SQL definitely is the wrong way to do it. ... Your suggestion below about populating a temporary table below, then working with its contents as the result set, possibly would work for the original poster. ... you'll need to do the same thing you'd need to do with RPG....build an actual temporary work file. ...
    (comp.sys.ibm.as400.misc)
  • Re: untypical problem
    ... I've done a lot of work using SQL to find patterns in time series ... stock data for automated trading strategies, e.g., using stock prices, ... > To the original poster, I'd like to ask, what RDBMS do you use? ... I believe Oracle and DB2 do. ...
    (comp.databases)
  • Re: untypical problem
    ... I've done a lot of work using SQL to find patterns in time series ... stock data for automated trading strategies, e.g., using stock prices, ... > To the original poster, I'd like to ask, what RDBMS do you use? ... I believe Oracle and DB2 do. ...
    (comp.databases)