using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace MMDAL.Query.TermsSet
{
    public class TermsSetQB
    {


        public const string GET_SELECTLIST_TERMSSET = @"SELECT
                                           TS.TERMSSETID           AS Id,
                                           TS.TERMSSETNAME         AS Name,                                        
									       TS.TERMSSETTYPE  AS TermsSetType
                                       FROM MTERMSSET TS
                                       WHERE TS.STATUS = 1
									   AND (@name = '' OR TS.TERMSSETNAME LIKE '%' + @name + '%');";
    }
}