Select 'Like' ODBC / MS Access / PHP

I am trying to do a select 'LIKE' statement but I am not returning any results, here is what I am trying:

$get = "SELECT item FROM table WHERE item LIKE 'D123-78*'";
$ex = odbc_exec($conn, $get);

But in access there are several items:

D123-78-567
D123-78-432
D123-78-113

What is the problem? Unless I'm misunderstanding you, that's how LIKE is supposed to work.

You might want to try % instead of *.