<div>
You can use &quot;select case&quot; in MSSQL e.g.<br />
<br />
select case when price=1 then 122 else price end as price from (seachquery) 
</div>


You can use "select case" in MSSQL e.g.

select case when price=1 then 122 else price end as price from (seachquery)

<div>
aneeshattingal,<br />
The invoice is for billing purposes, If the the user entered the wrong price and I need to ajust it. &nbsp;That is how I determine if the price needs to be changed. &nbsp; So what I would like to create is a number field that appears next to each price, and then item by item except the price or change it. &nbsp;I hope that this helps you understand what I am trying to accomplish a little better.<br />
Thank you
</div>


aneeshattingal,
The invoice is for billing purposes, If the the user entered the wrong price and I need to ajust it.  That is how I determine if the price needs to be changed.   So what I would like to create is a number field that appears next to each price, and then item by item except the price or change it.  I hope that this helps you understand what I am trying to accomplish a little better.
Thank you

<div>
accept the price I ment Sorry
</div>


<div>
accept the price I meant. &nbsp; I can't spell today
</div>


accept the price I meant.   I can't spell today

<div>
Please provide the table strucure 
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
I have an invoice that is genorated from a search of a Access database using asp VBscript. &nbsp; Once the invoice is created I would like to have a feild to change the price of each item in the repeat region seperately. &nbsp;For example if there is five items returned from the search and I need to change the price of three of them. &nbsp;How would I do it on the same page in the repeat region table.
</div>
</div>


Hi,
I have an invoice that is genorated from a search of a Access database using asp VBscript.   Once the invoice is created I would like to have a feild to change the price of each item in the repeat region seperately.  For example if there is five items returned from the search and I need to change the price of three of them.  How would I do it on the same page in the repeat region table.

How do I update multiple records from a search query

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.