Re: SQL Between

[Jonathan Mason <masonjo1@xxxxxxxxxxxxxxxx>]

Hi Tony

The following two statements worked perfectly for me, in the first one the 
fields are all 2 digit numeric and in the second one they are all two 
characters.

select * from masonj02/tstpsql                                     
 where ((ncc * 1000000) +                                          
        (nyy * 10000) +                                            
        (nmm * 100) +                                              
        (ndd)) between 19980101 and 19981231                       

select * from masonj02/tstpsql                                     
 where (acc || ayy || amm || add) between '19980101' and '19981231'


All the best

Jonathan


-----Original message-----
From: tony.richardson@xxxxxxxxxxxx
Date: Fri, 11 Mar 2005 12:30:35 +0000
To: midrange-l@xxxxxxxxxxxx
Subject: SQL Between

> I need to run an SQL BETWEEN to compare some date fields. The problem Iâ??m 
> having is our dates are stored in separate fields (century, year, month, and 
> day). I've tried to concatenate the fields together, but that doesn't seem to 
> work.
> 
> Anyone out there done this before?
> 
> 
> 
> 
> --
> Thanks,
> 
> Tony Richardson
> 
> 
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 


Jonathan Mason
www.astradyne-uk.com