udf

Mline UDF - Return specific line

Tagged:

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

Tagged:

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.

Proper UDF - Capitalize String as Proper Names

Tagged:

The ufn_Proper() UDF for SQL Server is similar to the VFP Proper() function. It additionally allows to specify a set of delimiters.

Strextract UDF - Retrieves String Between Two Delimiters

Tagged:

The ufn_StrExtract() UDF for SQL Server is similar to the VFP StrExtract() function.

Alines UDF - String Split

Tagged:

The ufn_Alines() UDF for SQL Server is similar to the VFP Alines() function but w/o additional parameters.