Sergey's blog

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.

$SAMPLECODE$


IF EXISTS (SELECT * FROM sysobjects WHERE name = N'ufn_Proper')
DROP FUNCTION ufn_Proper
GO

Alines UDF - String Split

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

Pages

Subscribe to RSS - Sergey's blog