Hello,                                                                     
                                                                            
 I am really not having luck with this statement.  I am receiving no output 
 and I honestly thought that this command would do it.  It is giving me     
 problems with the WHERE (node_name...)  Does anyone know what I am doing   
 wrong?  Thanks!                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            
  SELECT node_name, scheduled_start, schedule_name, status                  
  FROM events                                                               
  WHERE (node_name LIKE 'HMCH%' OR node_name LIKE 'HMPG%')                  
    AND scheduled_start > getdate() - 1                                     
  ORDER BY node_name                                                        
                                                                            
                                                                            
                                                                            
                                                                            
                                                                            




Joni Moyer
Systems Programmer
joni.moyer AT highmark DOT com
(717)975-8338