<div>
Try this..<br />
<br />

<pre><code id="code-20-41920743-1">Select xxxxxx,
Case 
       When PickupPostalCode LIKE 'J0W%' THEN 'km'
       When DeliveryPostalCode LIKE 'J0W%' THEN 'km'
       When DeliveryZoneId = 2175 THEN '01'
       When ScheduledOrderNo &gt; 0 THEN 'sh'
       ELSE CAST(DeliveryZoneId AS VARCHAR(100)) END AS [DeliveryZoneId]
From xxxxxxxxxxxxxx</code></pre>
</div>


Try this..



Select xxxxxx,
Case 
       When PickupPostalCode LIKE 'J0W%' THEN 'km'
       When DeliveryPostalCode LIKE 'J0W%' THEN 'km'
       When DeliveryZoneId = 2175 THEN '01'
       When ScheduledOrderNo > 0 THEN 'sh'
       ELSE CAST(DeliveryZoneId AS VARCHAR(100)) END AS [DeliveryZoneId]
From xxxxxxxxxxxxxx

<div>
Hi Pawan<br />
Same error<br />
Conversion failed when converting the varchar value ....
</div>


Hi Pawan
Same error
Conversion failed when converting the varchar value ....

<div>
Can you please post the entire query ?
</div>


<div>
Thank you very Much.<br />
worked.
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
can you please help, (Im usning SQL 2008 R2)<br />
Error<br />
Conversion failed when converting the varchar value 'KM' to data type int.<br />
Conversion failed when converting the varchar value 'sh' to data type int.<br />
<br />
Select xxxxxx,<br />
Case <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; When PickupPostalCode LIKE 'J0W%' THEN 'km'<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; When DeliveryPostalCode LIKE 'J0W%' THEN 'km'<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; When DeliveryZoneId = 2175 THEN 01<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; When ScheduledOrderNo &gt;&nbsp;0 THEN 'sh'<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ELSE DeliveryZoneId END AS [DeliveryZoneId]<br />
From xxxxxxxxxxxxxx<br />
<br />
Your help is appreciated.
</div>
</div>


Hello,
can you please help, (Im usning SQL 2008 R2)
Error
Conversion failed when converting the varchar value 'KM' to data type int.
Conversion failed when converting the varchar value 'sh' to data type int.

Select xxxxxx,
Case 
	 When PickupPostalCode LIKE 'J0W%' THEN 'km'
	 When DeliveryPostalCode LIKE 'J0W%' THEN 'km'
	 When DeliveryZoneId = 2175 THEN 01
	 When ScheduledOrderNo > 0 THEN 'sh'
	 ELSE DeliveryZoneId END AS [DeliveryZoneId]
From xxxxxxxxxxxxxx

Your help is appreciated.

SQL 2008 Conversion failed

Microsoft SQL Server 2008 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. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

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.

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.