Hi Kevin,

What i wanted to use the name spaces for is to separate SQL code in a C# file below.

i.e.

using System;

namespace FuturePathDev.Sample.Business.SQLCommands
{
	public class SQLQueries
	{
		public SQLQueries()
		{
		}
	}


	namespace CasesData
	{
		public class CasesSQL
		{
			public string GetAll()
			{
				return "select a.case_id, b.title, c.country," +
						"a.expir_date from patents a, cases b," +
					  "country c where a.case_id = b.case_id and" + 
						"a.country_id = c.country_id";
			}

			public string GetByID(string pCaseID)
			{
				return "select case_id, title from cases " + 
					"where case_id = '" + pCaseID + "'" ;
			}
		}
	}


	namespace PatentData
	{
		public class PatentsSQL
		{
			public string GetAllPatents()
			{
				return "select a.case_id from patents a";
			}
		}
	}


}

Thanks Bonnie, Kevin, Neil