<div>
it is MS SQL 2008<br />
<br />
what if the number is larger ? &nbsp; can I do varchar(150) for example ?
</div>


it is MS SQL 2008

what if the number is larger ?   can I do varchar(150) for example ?

<div>
Sure you can. &nbsp;But ... do you really have 150 digits?
</div>


Sure you can.  But ... do you really have 150 digits?

<div>
No ... was just saying :) &nbsp;thx !
</div>


<div>
<div class="content wysiwyg-content">
I am selecting a number field and need to convert it to 'string' because I have an export function which doesnt work with large numbers, but if I convert to string it should work.<br />
<br />
Select number <br />
from table<br />
<br />
?
</div>
</div>


I am selecting a number field and need to convert it to 'string' because I have an export function which doesnt work with large numbers, but if I convert to string it should work.

Select number 
from table

?

Convert value to string

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.