in your query, refer to the following part,
convert(varchar(2), 'Business Day')
Replace 'Business Day' to the column name Business Day and your query will work.
select * from BusinessDays where Convert(varchar(2), DatePart(day, getdate())) = convert(varchar(2), [Business Day]);
Hope this helps