From: contracer11@gmail.com   
      
   Hi,   
   Please, can you help me how extract nth word in string ccs.errormessage ?   
      
      
   Select n.caption, ccs.errormessage FROM APM_CurrentComponentStatus ccs WITH   
   (NOLOCK)   
   INNER JOIN APM_Application a WITH (NOLOCK) ON ccs.ApplicationID = a.ID   
   INNER JOIN Nodes n WITH (NOLOCK) ON a.NodeID = n.NodeID   
   where ccs.ErrorMessage LIKE '%hit%'   
   order by 2 asc   
      
      
      
      
   ORACLE01 FS /apl/orawpsp hit 90% usage -> 533 MB available   
            FS /bd1/orawppdata/sys hit 90% usage -> 199 MB available   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)