>>>>>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.

Can you please post some example data and what you want from it?