Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Comparable FoxPro/SQL Server functions
Message
 
 
To
08/03/2004 12:31:06
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00884143
Message ID:
00884159
Views:
9
>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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform