/// <remarks>
/// I wrote this because we had a legacy database that stored multiple
/// address fields in a single column (as in 'High Street|London|E1 1AA',
/// but somewhat longer) and we needed to retrieve a single field in a
/// stored procedure.
/// </remarks>
/// <param name="colName">The name of the database column.</param>
/// <param name="sep">The field separator character.</param>
/// <param name="numFields">The number of fields in the column.</param>
/// <param name="fieldToGet">Which field we want to retrieve.</param>
/// <returns>Some really nasty SQL.</returns>
private string GetFieldSplitterSql(string colName, char sep, int numFields, int fieldToGet)
{
	string s = colName;

	for (int i = 0; i < fieldToGet; i++)
	{
		s = "SUBSTRING(" + s + ", 1 + CHARINDEX('" + sep + "', " + s + "), 999)";
	}

	if (fieldToGet < numFields) // not the last field
	{
		s = "SUBSTRING(" + s + ", 1, CHARINDEX('" + sep + "', " + s + ") - 1)";
	}

	return s;
}