Need help with active record

[eluser]profsoni[/eluser]
Hi,

i have this code in model:

Code:

$query=$this->db->like($field,'Insert%')
                ->get($table);

Basically, i was trying to get data that contains the word 'Insert'. But this doesn't work and num_rows always return 0.

i've run the query in database directly and it's return values.

i'm using sql server as database and sqlsrv driver.

Can anyone tell me what's wrong with this?

Thanks in advance.