如何在SQL Server中的两个Weekday名称字段之间获取Weekday名称

您是否可以在Where子句中使用Between运算符并添加一个INT列，因为它们之间不能在nvarchar上起作用？

            Create table #temp(
            data int,
            dayN Nvarchar(100)
            ,dayc int
            )
            SELECT * FROM #TEMP
            Insert into #temp values (10,'Monday',2)
            Insert into #temp values (20,'tuesday',3)
            Insert into #temp values (30,'wednesday',4)
            Insert into #temp values (40,'thursday',5)
            Insert into #temp values (50,'friday',6)

            SELECT Data
            FROM #TEMP
            where dayN between 'Monday' and 'Wednesday'
            --Above query gives wrong result

            SELECT Data
            FROM #TEMP
            where dayC between 3 and 6