How do you do wild cards?

Ok guys... Last one for the week I swear. I want to thank all of those who have helped in the past as well.

$cur= odbc_exec( $cnx, "SELECT * FROM data WHERE (data.ctname like 'Steve Rodda')");

Pulls results contaning steve rodda in the ct field.

$cur= odbc_exec( $cnx, "SELECT FROM data WHERE (data.ctname like 'Steve*')");

Pulls absolutly nothing...

How do you use wildcards?

Thanks
Steve

Try:

SELECT * FROM data WHERE (data.ctname like '%Steve%')