>I am trying to pass characters like '& \ ?' from a delimited text file to SQL Server. Two lines in the file look like this.
>
>2566| 3|BURG | Thomas && Chelsea
>2567| 3|ROBB | Summer && Perkins
>
>I am unable to even get the fourth field to evaluate in a variable when I parse the text file. My objective is to parse the file and insert the records line by line into a SQL2000 table.In your example, VFP thinks the '&&' combination is the reserved char for inline comments.
It should work if you trap them and replace them (STRTRAN) with the equivalent CHR(38).