Week number in a Month
$SAMPLECODE$
Mline UDF - Return specific line
The ufn_Mlines() UDF for SQL Server is similar to the VFP Mline() function but w/o third parameter.
It's more an example than finished UDF. I didn't do much testing on it.
IsNumericEx UDF - Data type aware
The built-in SQL Server ISNUMERIC() function determines if character expression can be converted to one of the numeric types. The ufn_IsNumericEx() function accepts the second parameter - the data type to convert to and checks also for characters illegal for that data type. It doesn't check if the numeric value is in the range for specified data type though.
Strextract UDF - Retrieves String Between Two Delimiters
The ufn_StrExtract() UDF for SQL Server is similar to the VFP StrExtract() function.
Proper UDF - Capitalize String as Proper Names
The ufn_Proper() UDF for SQL Server is similar to the VFP Proper() function. It additionally allows to specify a set of delimiters.
Alines UDF - String Split
The ufn_Alines() UDF for SQL Server is similar to the VFP Alines() function but w/o additional parameters.