[NOVICE] converting mac-adress type to string

From: Michael Cochez <michaelcochez(at)yahoo.com>
Date: Thu Sep 20 2007 - 11:35:13 EDT

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. Received on Thu Sep 20 11:37:09 2007