<div>
SELECT * FROM ur_table<br />
WHERE unit_code = (CASE WHEN host_NAME() = 'MATEEN' then '21' <b>ELSE unit_code</b> end)<br />
<br />
cannot be else unit_code end , I want to show records of all units if user is not mateen.
</div>


SELECT * FROM ur_table
WHERE unit_code = (CASE WHEN host_NAME() = 'MATEEN' then '21' ELSE unit_code end)

cannot be else unit_code end , I want to show records of all units if user is not mateen.

<div>
Oh no,<br />
<br />
it is working, thanks
</div>


<div>
<div class="content wysiwyg-content">
SQL Server 2005<br />
<br />
in sql query to construct a where clause for<br />
if host_name() = 'MATEEN' then<br />
&nbsp; &nbsp; unit_code = '21'<br />
else<br />
&nbsp; &nbsp;ignore unit code matching and show all records<br />
end if<br />
<br />
<br />
I tried <br />
where &nbsp;( &nbsp;unit_code = &nbsp;'21' and host_name() = &nbsp;'MATEEN') or 1=1 )<br />
but it is showing all records in all machines including MATEEN'S P.C.
</div>
</div>


SQL Server 2005

in sql query to construct a where clause for
if host_name() = 'MATEEN' then
    unit_code = '21'
else
   ignore unit code matching and show all records
end if


I tried 
where  (  unit_code =  '21' and host_name() =  'MATEEN') or 1=1 )
but it is showing all records in all machines including MATEEN'S P.C.

Conditionala where clause in sql query

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.