LIKE clause

--------------153D231F1568F82C6ADD9555 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Does anybody know a way to make a comparison between two strings: one is a column, the other is a variable string caugth as a parameter. The matter is that I must use wildcards, and they can be used within a quoted literal . PROCEDURE P1(string VARCHAR(5)) ... SELECT ... FROM ... WHERE column LIKE '*string*' ; <-- This is incorrect. Thecomparison will take place between the string in the column and the literal "string" --------------153D231F1568F82C6ADD9555 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <HTML> <P>Does anybody know a way to make a comparison between two strings: one is a column, the other is a <U>variable</U> string caugth as a parameter. The matter is that I must use wildcards, and they can be used within a quoted <U>literal&nbsp;</U> . <P>PROCEDURE P1(string VARCHAR(5)) <BR>... <BR>SELECT ... FROM ... WHERE column LIKE '*string*' ;&nbsp; &lt;-- This is incorrect. The comparison will take place between the string in the column and the literal "string" <BR>&nbsp; <BR>&nbsp; <BR>&nbsp;</HTML> --------------153D231F1568F82C6ADD9555--