--0-1114098451-979638182=:85432
Content-Type: text/plain; charset=us-ascii


Nathan

You need to create a VIEW of the table the calculated field requires

Use Like to restrict the fields returned and calculate the field

as follows LEFT(field,CharIndex(search str, Field,start search position)-1) as CalcField

Then use DTS with this VIEW  

  Nathan Crawford <nathan.crawford@f...> wrote: 
All,
I am using DTS to send SQL 7 data into a flat text file. I want to take
partial records from a field up to the first comma in the field. What is
the query format for this action?

Thanks,
Nathan P. Crawford







---------------------------------
Do You Yahoo!?
Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.