Date:         Thu, 11 Dec 1997 18:23:47 -0500
Reply-To:     "Childs, Randy" <RCHILD@ABTI.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Childs, Randy" <RCHILD@ABTI.COM>
Subject:      Re: function or expression
Comments: To: jwang@PICARD.TAMU.EDU
Content-type: text/plain; charset=US-ASCII

     If you are using this function in a WHERE clause, you can use the
CONTAINS function.  However, it cannot be used in an IF-THEN-ELSE type
of statement.  You can also use a question mark (?) in place of the word
CONTAINS.
 
     WHERE CHAR_VAR CONTAINS 'text string';
 
     -or, equivalently-
 
     WHERE CHAR_VAR ? 'text string';
 
                              Randy Childs
                              Alpha-Beta Technology
                              rchild@abti.com