Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Val() function in sql
Message
 
 
To
15/01/2008 10:12:55
Issam Mansour
Jordan Business Machines
Amman, Jordan
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01281915
Message ID:
01281916
Views:
6
There's no direct equivalent of VFP VAL() function in SQL Server. You can use CAST() if string represents a valid number. Check also http://berezniker.com/content/pages/sql/microsoft-sql-server/isnumericex-udf-data-type-aware

>
>What is the function on sql can be used instead of val() on vfp.
>
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform