SQL語法問題(編號：2248)

請問一下, 在SQL語法中能不能以下列方式來執行??
Dim mWeek as String
Dim MySQL as String
mWeek ="週一"
MySQL = "SELECT 日期,排程, &Chr(39) &mWeek &Chr(39) FROM
SCHE ORDER BY 日期"