I wish to parse a description field by the space between
each word and fit as many whole words into descr1, descr2,
descr3, and descr4 fields as possible.

Any suggestions?

CREATE TABLE [dbo].[ORDERS] (
[CATNO] [char] (20) ,
[DESCR] [char] (250) ,
[DESCR1] [char] (17) ,
[DESCR2] [char] (10) ,
[DESCR3] [char] (20) ,
[DESCR4] [char] (20) ,
)

INSERT INTO orders (catno, descr) VALUES('PHP-
43622422', 'QUARTZ BULB, 500 WATTS/125 VOLTS,
PHILIPS NO PHL-500T3Q/CL/P, 2000 HOURS')

I am not quite sure what you want but think you want to break each part of a
description out into seperate fields. Each part is delimited by a space ??

If yes then you can look into an ActiveX Script transformation and use the
VB SPLIT() function.

BTW Your design of table is odd.

You are potentially going to store the same info twice. You are also
potentially going to break 1st Normal Form. You are storing repeating
attributes. All CATNO attributes should have the same amount of DESCRn
attributes as every other.



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Mark" <mark_d_thompson (AT) hotmail (DOT) com> wrote