[thelist] SQL: BETWEEN versus (Greater Than and Less Than)

[Jason Handby]

Hi Anthony,


> convert(char(8), create_dt, 112)  >= '20070319' and 
> convert(char(8), create_dt, 112)  <= '20070319'


Didn't you mean to write

  convert(char(8), create_dt, 112)  >= '20070319' and 
    convert(char(8), create_dt, 112)  < '20070320'


...?



Jason