<div>
Give this a whirl..<br />
<br />
CAST(ISNULL(itemID, 'Generic') as varchar(25))
</div>


Give this a whirl..

CAST(ISNULL(itemID, 'Generic') as varchar(25))

<div>
<pre><code id="code-20-38362324-1">SELECT ISNULL(CAST(itemID AS VARCHAR(8)), 'Generic')</code></pre>
</div>


SELECT ISNULL(CAST(itemID AS VARCHAR(8)), 'Generic')

<div>
thanks Dale and Jim for the answer and thorough explanation
</div>


thanks Dale and Jim for the answer and thorough explanation

<div>
<div class="content wysiwyg-content">
Hi ALL, <br />
<br />
Hows it going?<br />
<br />
I have a simple question, I have this this query<br />
<br />
ISNULL(itemID, 'Generic')<br />
<br />
Which basically gives me an error message saying that I cant convert integer to 'Generic' and I know there is a convert or something similar I can use to convert integer into varchar. <br />
<br />
Can you please tell me how to correctly write this code. <br />
<br />
Cheers, <br />
<br />
J3di
</div>
</div>


Hi ALL, 

Hows it going?

I have a simple question, I have this this query

ISNULL(itemID, 'Generic')

Which basically gives me an error message saying that I cant convert integer to 'Generic' and I know there is a convert or something similar I can use to convert integer into varchar. 

Can you please tell me how to correctly write this code. 

Cheers, 

J3di

SQL Query ISNULL with convert

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.