>>>>Hi,
>>>>
>>>>I want to specify in the SQL Select that Day of the Week in Monday. I know that in VFP it would be the function DOW().
>>>>That is, in VFP I would use
>>>>

>>>>where DOW(date_field) = 2
>>>>

>>>>What function could I use in SQL Server?
>>>>
>>>>TIA
>>>

>>>SET DATEFIRST = 1
>>>

>>>Check my answer to your previous question.
>>
>>Something I still do not understand. If you want to make sure that only Mondays are selected with a SQL Select, you would want to include Something in the WHERE expression. How do you use the "SET DATEFIRST .." in the WHERE expression of the SQL Select?
>
>No, SET DATEFIRST is to make sure what day is supposed to be first in the week Monday or any other.
>Check DATEPART() function.

I found this page

https://www.tutorialsteacher.com/sqlserver/datename

and it appears that the DateName should return the DOW character value. But so far, I have not found how to use this function (DateName) to get only Mondays. I will keep working on this.
Thank you.

UPDATE. I think I know what I was missing. It was the parameter DW in the DatePart function.
Again, thank you.