I have been programming in C for quite some time, but until recently I was not aware that you could specify column widths and string limits using variables. I have neither seen this functionality used in any projects until I started working with OpenSER.

Specify a variable column width:

printf("%*d", width, number);

Specify a variable number of characters from a string:

printf("%.*s", width, string);

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

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

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