Re: SQL Between

[vhamberg@xxxxxxxxxxx]

Tony

Are you comparing against date data types or against numeric fields, as the 
other posts suggest? This is quite a common exercise. I recommend concatenating 
the various components - you need to convert to character first, but I think 
that is less costly for performance than multiplication. That's the usual 
common wisdom, anyway. The char() function will convert a number to a string, 
then you can substring, etc., to your heart's content. And the decimal( ) 
function can take a character string and convert to a number.

HTH
Vern

-------------- Original message -------------- 

> 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. 
>