[eluser]jedd[/eluser]
[quote author="frist44" date="1262039380"]
Using $this->db->select, is there a way to say 'SELECT column as name' ?
[/quote]
If you read the SQL FAQ in the wiki - [url="http://codeigniter.com/wiki/SQL"]http://codeigniter.com/wiki/SQL[/url] - you'll find a few hints in there.