<div>
SELECT (CAST(inv_no AS varchar) + &quot;&nbsp;- &quot;&nbsp;+ CONVERT(varchar, date, 101)) as field<br />
FROM billing<br />
<br />
that should do the trick :)
</div>


SELECT (CAST(inv_no AS varchar) + " - " + CONVERT(varchar, date, 101)) as field
FROM billing

that should do the trick :)

<div>
Thanks for the help, mcy22. &nbsp;that totally did the trick.
</div>


Thanks for the help, mcy22.  that totally did the trick.

<div>
<div class="content wysiwyg-content">
I am attempting to write a querie that will display in a drop down dialogue box in VB that will show the invoice number and the date of the invoice together. &nbsp;I thought that this would work:<br />
<br />
SELECT (inv_no + ' - ' + date) as billinfo from billing.<br />
<br />
I get the error Operand type clash: date is incompatible with int<br />
<br />
inv_no is an int field in the db and date is a date field.<br />
<br />
Anone have any ideas as to how to do this?<br />
<br />
Thanks<br />

</div>
</div>


I am attempting to write a querie that will display in a drop down dialogue box in VB that will show the invoice number and the date of the invoice together.  I thought that this would work:

SELECT (inv_no + ' - ' + date) as billinfo from billing.

I get the error Operand type clash: date is incompatible with int

inv_no is an int field in the db and date is a date field.

Anone have any ideas as to how to do this?

Thanks


Operand type clash: date is incompatible with int

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.