Need help with active record

[eluser]profsoni[/eluser]
This is the code :

Code:

$query=$this->db->like('Username','Son')
                ->get('UserTable');

I also have try this :

This Works :

Code:

$query=$this->db->query("select * from UserTable where Username like '%Son%'");

This doesn't :

Code:

$query=$this->db->query("select * from UserTable where Username like '%Insert%'");

In the Sql Server there is Username 'InsertSoni'.

I'm using Sql server 2005, btw and sqlsrv driver.

Thanks