>I remember seeing some little tool one time that would take a VFP Select statement and convert it to a SQL Statement that was compatible with SQL Server. Anyone know what it is and where I can get it?
>
>Also - I've been told this morning that I will be in charge of writing stored procedures in SQL Server now. I've never written a SQL Server stored procedure (eeek eeek). Is there a tool that will do some type of converstion from VFP to this? Anyone suggest a fast way to learn how to make these stored procedures? (seeing how its my responisiblity for this is starting...ummm... in about 30 minutes...ha)

Victor,

SQL Server syntax is very much like VFP's. In fact, if I recall correctly, VFP is SQL-92 compatible.

There are two or three things that cause me the most problems.

1. SQL Server syntax doesn't need the ";" for line continutation. In fact, just using a STRTRAN() to remove them works fine.

2. The INTO clause comes before the field list.

3. You've got to declare your variables.

4. Rather than BETWEEN() you use BETWEEN val1 AND val2.

5. Rather than INLIST(), you use var IN...