Concatenating Problem

[James1981]

Hi I'm trying to concatentate two varchar fields together in a query but it returns null always. Below is the code:

SELECT source + ' (' + card_digits + ')' AS reference FROM myTable

Any ideas?

Thanks, James

 

[sunila7]

Hi,

Try one of these

SET CONCAT_NULL_YIELDS_NULL OFF

SELECT source + ' (' + card_digits + ')' AS reference FROM myTable

OR

SELECT ISNULL(source,'') + ' (' + ISNULL(card_digits,'') + ')' AS reference FROM myTable


Sunil

 

[KraGiE]

SELECT [Reference] = (Source + ' ' + Source2) From Table Where...

.NET Developer/Contracting Consultant.
<a href=&quot;

http://www.inklass.com&quot;>InKlaSs.com</a>