I would like to remove the "Null" in my week Column. Any help? I tried screenshots provided

error

what i tried

CodePudding user response：

I think you could try:

delete from [BKC_Menu_Analysis].[dbo].[FBBKCCompsWeekly] where week is NULL

CodePudding user response：

You should try:delete from[BKC_Menu_Analysis].[dbo].[FBBKCCompsWeekly] where is NULL