/// <summary>
/// Returns the first non null value, same as SQL's COALESCE()
/// </summary>
/// <param name="p">Args array</param>
/// <returns>First non null value</returns>
public static String Coalesce(params object[] p)
{
	foreach (Object o in p)
	{
		if (o != DBNull.Value && o != null)
		{
			return o.ToString();
		}
	}
	return "";
}

/// <summary> /// Returns the first non null value, same as SQL's COALESCE() /// </summary> /// <param name="p">Args array</param> /// <returns>First non null value</returns> public static String Coalesce(params object[] p) { foreach (Object o in p) { if (o != DBNull.Value && o != null) { return o.ToString(); } } return ""; }