All, I want to do a LIKE on a column of type macaddr, looking (for example) for all MAC addresses with the prefix "00:80", and so on. There's no ~~ operator for macaddr though... I tried casting macaddr to text, but that's undefined apparently (WTF?) - any ideas? Regards, Phil +----------------------------------+ | Phil Mayers, Network Support | | Centre for Computing Services | | Imperial College | +----------------------------------+
