I have a table that contains the last name, first name, middle initial, and
suffix all together as one data element called "FULL NAME"; I need to have
this broken into separate data columns in my return query and have been
attempting to use CHARINDEX as a means to accomplish this task but to no
success. Please advise on how to best accomplish this task, thanks!

B.L.

Couple of ways to do this

The fastest way is to use the Source's language to split it before it
enters the pipeline.

The other way is of course to use an Active X transform and use SPLIT()

Allan

"B.L." <BL (AT) discussions (DOT) microsoft.com> wrote