>Does anyone know of a document listing common comparable functions between VFP & SQL Server? I'm looking for SQL Server equivalents (or at least similar to) to common VFP functions used in SQL select statements such as between() and at().
In SQL Server you can use BETWEEN operator in T-SQL. For example,
IF @sumenumber BETWEEN 100 AND 200
The AT() function can be replaced in most cases with PATINDEX() or CHARINDEX() functions. I also published AT() and RAT() UDF's for SQL Server in March issue of UT magazine.
--sb--