Hi,

I have an overloaded column from a csv file that can have two different
values. The rules are, if the column is numeric then that should be
put in the numeric column. If it is alpha-numeric, then I want to put
it into a string column.

I've tried to use the derived column transformation but it does not
have any functions to check for the type. Seems like it should.
Please help....

Thanks,
James

Check in Books Online about using CASE...

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"James" <jamesbench (AT) gmail (DOT) com> wrote