SQL 'Like' operator

Hi all --

Is it possible to use the LIKE operator using a host variable in PRO*C ?? I need to search VARCHAR fields with just the first few letters. Something like -

SELECT ename
FROM emp_table
WHERE ename LIKE :host_variable ;
/* 'host_variable' contains the string 'stev' and it should pull out

    'steven'
*/

Thanks in advance,

Atul Batra
abatra_at_unix1.sncc.lsu.edu Received on Sun Jul 28 1996 - 00:00:00 CEST