Cacher is the code snippet organizer for pro developers

select '' as Value, 'Region (Any)' as TextField
UNION ALL
SELECT
r.ItemID AS Value, '(' + c.CountryDisplayName + ') ' + r.RegionName AS TextField

FROM CTG_Region r
  INNER JOIN
CMS_Country c
  ON r.RegionCountry = c.CountryName
  
  
  

select '' as ItemID, 'Guiding (Any)' as GuideName, 0 as ItemOrder
UNION ALL
select ItemID, GuideName, ItemOrder
from CTG_Guide
order by ItemOrder asc


search by column with multiple values
String.Format("TourLevel = '{0}' or TourLevel like '{0};%' or TourLevel like '%;{0};%' or TourLevel like '%;{0}'", level);