From: emurphy42@socal.rr.com   
      
   Plamen Ratchev wrote:   
      
   > You can do that with IF statement or dynamic SQL. The problem is even if   
   your predicate is formed correctly:   
   >   
   > WHERE (@KeywordString IS NULL OR FREETEXT(P.productname, @KeywordString))   
   >    AND ...   
   >   
   > or   
   >   
   > WHERE CASE WHEN @KeywordString IS NULL   
   >             THEN 'T'   
   >             WHEN @KeywordString IS NOT NULL AND FREETEXT(P.productname,   
   @KeywordString)   
   >             THEN 'T'   
   >             ELSE 'F'   
   >        END = 'T'   
   >    AND ...   
   >   
   > You will get error "Null or empty full-text predicate." because the FREETEXT   
   predicate is always evaluated.   
   >   
   > To avoid this problem you can use IF:   
   >   
   > IF @KeywordString IS NOT NULL   
   > SELECT ...   
   > FROM ...   
   > WHERE FREETEXT(P.productname, @KeywordString)   
   >    AND ...   
   > ELSE   
   > SELECT ...   
   > FROM ...   
   > WHERE ...    
   >   
   > Or construct your SQL dynamically.   
      
   Why not:   
      
   SELECT ...   
   FROM ...   
   WHERE ...   
     AND (FREETEXT(P.productname, COALESCE(@KeywordString,''))   
            OR @KeywordString IS NULL)   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)