converting mac-adress type to string

[Michael Cochez <michaelcochez(at)yahoo(dot)com>]

Hello,
I want to create a view where the mac address of a table is seen as a string i was thinking about something like this : 
SELECT some_function_to_convert(mac_address) FROM table;
is this possible, and what function do i need to use?
why is it so difficult to change a view, things like changing column names/quantity
 seem to be impossible??

Michael Cochez

---

Fussy? Opinionated? Impossible to please? Perfect.  Join Yahoo!'s user panel and lay it on us.