<div>
<pre><code id="code-20-37862928-1">SELECT CAST ( [yourField] AS NVARCHAR(50) ) 
SELECT CONVERT( NVARCHAR(50), yourField ) </code></pre>
<br />
CREATE VIEW &lt;yourView&gt; AS <br />
&nbsp;SELECT CAST(... ) <br />
<br />
<br />
See <a href="http://msdn.microsoft.com/en-us/library/aa226054(v=sql.80).aspx" rel="ugc nofollow">MSDN</a>
</div>


SELECT CAST ( [yourField] AS NVARCHAR(50) ) 
SELECT CONVERT( NVARCHAR(50), yourField ) 


CREATE VIEW <yourView> AS
 SELECT CAST(... )


See MSDN [http://msdn.microsoft.com/en-us/library/aa226054(v=sql.80).aspx]

<div>
CREATE VIEW my_view<br />
AS<br />
select cast(id as sysname), &nbsp; &nbsp; -- this is the int field and you could use varchar or nvarchar instead of sysname<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;name<br />
FROM my_table<br />
GO<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms187928.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms187928.aspx</a><br />
<br />
Check implicit conversion chart at the end of above article.
</div>


CREATE VIEW my_view
AS
select cast(id as sysname),     -- this is the int field and you could use varchar or nvarchar instead of sysname
           name
FROM my_table
GO

http://msdn.microsoft.com/en-us/library/ms187928.aspx [http://msdn.microsoft.com/en-us/library/ms187928.aspx]

Check implicit conversion chart at the end of above article.

<div>
<div class="content wysiwyg-content">
How to convert the integer field to string &nbsp;a view sql?
</div>
</div>


How to convert the integer field to string  a view sql?

Sql Server 2005

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.