Sounds good, although I'm not sure how I would join the BorkerId. JOIN on what?
Here's the command now with BETWEEN. It threw an error.
INLIST(BrokerId, ' ', 'MC') AND WeekOf Between {01/01/1990},{12/31/2004})
>Just out of curiosity, try the following...
>
>- Put the "MC" and blank values into a cursor and then join the Broker ID that way
>
>- try WeekOf Between {01/01/1990} and {12/31/2004} , instead of the function
>
>Kevin
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people