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.