> I have created a cursor/table with a decode of the 4char 'header' of the image files stored in a general field of the master table.
>
> LEFT(Image,4) As ImageType, ;
>
> As an example ÿØÿà is stored when the image file is a jpg.
>
> I want to scan through the new table and replace the ÿØÿà with jpg where it occurs and 'jpg' is stored in myfile.
>
> My code
>
> replace mycsv.ImageType WITH myfile
>
> has no effect.
>
> Any ideas anyone?
>
> -Bryan

Maybe you are at the EOF()

replace mycsv.ImageType WITH myfile for ImageType='ÿØÿà'
or
update mycsv set ImageType=myfile where ImageType='ÿØÿà'

Regards
Tushar