Tom: ============================== You said:
Thanks for your post - I learned to put parenthesis round straight text matches to improve performance. does not have the dates in single quotes. I would code this as: >SELECT * FROM DALY_PROC_VIEW WHERE PRODDATE BETWEEN '07/01/2002' AND >'09/30/2002' AND GRADE= '1233' AND SMRYFLAG = 'M' ORDER BY >PRODDATE,CUR_CC,GRADE ============================= My reply: Because of an earlier post about problems with dates I have been trying to apply your suggestion about using single quotes around dates. In this particular instance I had tried that but it didn't make any difference. Normally, in my programming I set date variables and then compare the column values to the date variables. Per my "Invalid date values" post from before. I did a full unload data, drop table, recreate table and reload table on some key tables and I am having no (or at least fewer) errors. Must've been a gremlin lurking in one of tables or at least one of the indexes. I am going to review some of my programs that have been a little sluggish to see if some strategically placed parentheses might help. Thanks for the comments. Mike ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
