<div>
use isnull(colname,1)<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
If I have the following result of crosstab query<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Product 1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Product 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Product 3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Product4<br />
Customer 1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5.5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;666<br />
Customer 2 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;.222 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;454 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
Customer 3 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;258 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;252 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;365<br />
Customer 4 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
Customer 5 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;25 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;25 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />
<br />
Based on this result I would like to run another query that will leave the null value but replace the &nbsp;numbers with “1”<br />

</div>
</div>


If I have the following result of crosstab query
	Product 1	Product 2 	Product 3	Product4
Customer 1		5.5		666
Customer 2	.222		454	
Customer 3	258	252		365
Customer 4				
Customer 5	25		25	

Based on this result I would like to run another query that will leave the null value but replace the  numbers with “1”


replacing number

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.