<div>
I could not get what you want but<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42097876-1"><span>(</span>
<span>CASE @WeekDay</span>
<span>WHEN 1 THEN 'Monday' </span>
<span>WHEN 2 THEN 'Tuesday' </span>
<span>...</span>
<span>WHEN 5 THEN 'Friday'</span>
<span>else 'Weekend' end</span>
<span>)</span>
</code></pre>
</div>


<div>
or maybe you should use datepart<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42097880-1"><span>and DATEPART(weekday, wid.WorkDate) = @WeekDay</span>
</code></pre>
</div>


<div>
&gt;&gt;or maybe you should use datepart<br />
<br />
Excellent suggestion which is why I made it. &nbsp;;)
</div>


<div>
Huseyin -Your first comment was what I was trying to do but couldnt get it to work either<br />
<br />
I was using the DATENAME(weekday, wid.WorkDate) in my Select list so I guess I was focused in on using that and not doing the smart thing and converting it to a numeric value from the start. <br />
<br />
Thanks for the help
</div>


<div>
Worked like a charm. Thanks Slight
</div>


<div>
<div class="content wysiwyg-content">
I have a param I pass in that is a number representation of the day of Week. It will be either 1 - 5 for Mon - Friday<br />
<br />
Its in my Where clause so I am trying to set it to the day of week<br />
<br />
heres what I got....<br />
<br />

<pre><code class="code-1 nolinks" id="code-10-29016974-1"><span>and DATENAME(weekday, wid.WorkDate) = </span>
<span>(CASE WHEN @WeekDay = 1 THEN 'Monday'  </span>
<span>OR CASE WHEN @WeekDay = 2 THEN 'Tuesday'  </span>
<span>OR CASE WHEN @WeekDay = 3 THEN 'Wednesday'  </span>
<span>OR CASE WHEN @WeekDay = 4 THEN 'Thursday'  </span>
<span>OR CASE WHEN @WeekDay = 5 THEN 'Friday' ) </span>
</code></pre>
<br />
I know I can declare a variable and set the day that way but I would like to figure out how to do it this way!!<br />
<br />
Thanks
</div>
</div>


I have a param I pass in that is a number representation of the day of Week. It will be either 1 - 5 for Mon - Friday

Its in my Where clause so I am trying to set it to the day of week

heres what I got....

(CODE)

I know I can declare a variable and set the day that way but I would like to figure out how to do it this way!!

Thanks

SQL Syntax

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.