Re: how to update portion of the varchar type data

First, I would like to thank Martin and Norman for their help !!

Paul, to answer your question,

One of the project requirements that I am designing require the database to keep track of, example, quantity of
different item numbers, however, the exact number of item numbers is unknown , so to avoid keep asking our DBA to add columns, I think of using a varchar type field and keep all different items.
e.g column 1-3 of varchar(30) stores item 1 data, column 4-6 stores item 2 data etc etc.. Received on Fri Nov 29 2002 - 16:36:25 CST