RE: Inventory class proposal

[Alejandro Imass]

> 
> To show that this works well for us we currently
> have over 3 million item
> codes in our system comprised of stock and non
> stock.  My suggestion is that
> a varchar(23) should be the minimum and that since
> it's varchar storage
> space will not be an issue since it is trimmed
> before storage into the
> database table.
> 
> Also it may be better to rename the column from
> ItemNum to ItemCode since it
> is not necessarily a number.
> 

OK :-] good points.

I will be moving this discussion per Derek's sugestion
soon. Any person interested I think should susbscribe
there.



__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf!  It's FREE.
http://im.yahoo.com/