Looks good. I kept trying the other way, DELIMITED WITH TAB WITH CHARACTER ' '.
>Cindy, Ron,
>
> I think your suggestion is great! But It takes 2 steps to complete.
>Why not just change the delimiter to a space.
>COPY ALL TO xx DELIMITED WITH ' ' WITH CHARACTER TAB
>This way the file comes out the way it needs to be right from the start.
>
>I tested this first just to make sure I wasn;t giving any bad info.
>Let me know if this works ok for you.
>
>Scott Lay
>
scott@cspstudios.com