How can be better to select from db all users that have name begining from "A" ?

[eluser]New One[/eluser]
Thanks. But now the new problem is :

I have a $temp (it can be A or B or Z etc.)
how can i use it now?
$this->db->like("name”,"$temp%");
or
$this->db->like("name”,".$temp.%");
or
$this->db->like("name”,"$temp.%"); Doesn't help.