chars might not be the same length. should have stated that sorry but they will be going right

how if im using an sql script

will have to declare a variable for it to work

CurrencyCodePurchased is the name of the column it will be mapped to

so say I use something like this

SELECT *

...

im going to be moving the data from 1 table to another

ok

would I still be able to use SUBSTRING(TaxLotDescription,1,3) for pulling the first 3 chars.

how would I be able to do in tsql

III.Identify the amounts purchased / amounts sold

a.If the Quantity...

the info is coming from a table.

can you write scripts in a data flow i have never done it before.

the info is in a table but i need to do...

a right ya sorry was getting mixed up.

but the date has to be in the mmddyyyy for the system it goes into when the package runs

is that not what the code i posted is doing

thanks that worked

I used this

Left(TaxLotDescription,3)

and its not working. I then looked into my string function and left is not there right is. why is that

ok would you know any quick fix for this even a script or something to fix it

ok thanks

and if the string is not all the same length I will probably hit problems ?

I think it has something to do with the day and month. I think because neither go over the 12 it is getting confused I think anyway.

here is a few...