MAC Address attribute

Hi:

I need to store MAC Addresses. What is the standard way of storing this
type of attribute? Datatype? I can't find any discussions about this
anywhere.

Thx for any pointers.A MAC address is a binary value. You could store these using a binary data
type (binary or varbinary) or store the hex string notation in a character
datatype (char or varchar). One advantage of a binary data type is lower
space requirements and an advantage of a character data type is that it's a
bit easier to display by application programs.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"xAvailx" <bjzamora@.hotmail.com> wrote in message
news:1123625751.632127.142510@.g43g2000cwa.googlegr oups.com...
> Hi:
> I need to store MAC Addresses. What is the standard way of storing this
> type of attribute? Datatype? I can't find any discussions about this
> anywhere.
> Thx for any pointers.