Having a little problem. I was going to do the Filetostr on the .sql file I have. But it appears the file is in unicode or something. As it has a bunch of ascii chars.

If I copy and paste the contents of the file into query analyzer, no prob. But even if I do ? filetostr in the command window, I see all these chars.

Know of a way to strip these chars out?

Thanks.

>You're welcome.
>
>>Perfect. Once again Sergey, you da man!
>>
>>>Perry,
>>>
>>>If you have enough rights, you can use SQLEXEC() to send CREATE PROCEDURE script to SQL Server. Check Re: Execute .sql file Message #976613
>>>
>>>>I'm working on my contract helping to export the accounting data from the company I worked at that went bellyup.
>>>>
>>>>I need to get some SQL Server data into VFP. We created a new SP that formats the data how I need it. I'm going to have to run my conversion program against 40 or so databases.
>>>>
>>>>Is there a way to automate loading this new SP into a database I'm getting ready to convert?
>>>>
>>>>Thanks.
>>>>
>>>>PF