SQL SELECT Concat issue

[rustyfishbones]

Hi All,

I have the following piece of code for extracting from the DB and it works ok

However it does not concat the "trx-no" within the string and I get no error message

Any idea why I can't join the trx-no to the rest of the string?

Regards

Alan

[rustyfishbones]

Excellent that fixes the issue

Thanks Steve

Regards

Alan

[rustyfishbones]

final result is this

warehouse +

customer +

product +

"trx-by" +

CAST("trx-no" AS VARCHAR(20)) +

CAST("item-number" AS CHAR) +

CAST("line-number" AS CHAR)                AS TEST