Re: Help Data-Types

>> Just a quick question on a datatypes since I'm a young novice. What
the heck would an IP address go under? Text? <<

I'd do it as a VARCHAR(n), since you can have digits and dots in it, then add a CHECK() constraint to verify it. In Standard SQL-99 you have a SIMILAR predicate and in SQL and other products, you have grep() extensions you can use. Received on Sat Aug 17 2002 - 10:44:23 CDT