php query faircom

[iculus]

okay, so I've set up a dsn to a faircom database. I'm trying to query it from a php file

ie odbc_exec ($database, $query)

now when $query is

"select \"first"\ from \"Items\" where \"Description1\" like '123%'";

it returns all values that start with 123 however if query looks like this...

"select \"first"\ from \"Items\" where \"Description1\" like '%123'";

it doesn't return values ending in 123...

What gives? Any ideas?

Thanks,
dan

[iculus]

btw, running windows 2000.

[iculus]

Okay it should also be noted that...

like '%123%' works great however
I'm assigning
$fred = $var[1];

and

like '%$fred%' doesn't work.
ugghhh!
dan