<div>
<br />
you need to join the tables<br />
<br />
select * <br />
from Order<br />
inner join invoice on charindex(Order.orderNo, Invoice.OrderNo, 1) &gt;&nbsp;0<br />
<br />

</div>



you need to join the tables

select *
from Order
inner join invoice on charindex(Order.orderNo, Invoice.OrderNo, 1) > 0



<div>
cast as order.orderno as varchar<br />
<br />
select * <br />
from Order<br />
inner join invoice on charindex(cast(Order.order<wbr />No as varchar), Invoice.OrderNo, 1) &gt;&nbsp;0
</div>


cast as order.orderno as varchar

select *
from Order
inner join invoice on charindex(cast(Order.orderNo as varchar), Invoice.OrderNo, 1) > 0

<div>
<br />
To compare fields from two tables, they need to be linked in some way, in this case I'm using a join
</div>



To compare fields from two tables, they need to be linked in some way, in this case I'm using a join

<div>
<div class="content wysiwyg-content">
I tried to use a where statment on my code but its not working<br />
<br />
select * from Tablename<br />
Where &nbsp;Order.OrderNo like (Invoice.OrderNo +'%')<br />
Example:<br />
Order.OrderNo = 1000<br />
Invoice.OrderNo = 1000C<br />
Is there another way to do that?<br />
<br />
Thanks
</div>
</div>


I tried to use a where statment on my code but its not working

select * from Tablename
Where  Order.OrderNo like (Invoice.OrderNo +'%')
Example:
Order.OrderNo = 1000
Invoice.OrderNo = 1000C
Is there another way to do that?

Thanks

SQL 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.