NULL Values in concatonation select

[macleanb]

Hi

I am trying to select two columns (Text) liek so:

Select TB_ID + '|' + TB_Ref from MyTable


I was expecting to get either:

"|ABC"
A123|"
or
"A123|ABC"

However I only seem to get the last version, all rows where either ID or REF are null fail to calculate the concatonated string - any advice or alternative strategies to achieve this?


Many Thanks

 

[Norie]

I don't know if it will make a difference but try replacing + with &.

If that's no use tou might want to take a look at the Nz function.

By the way is there any criteria or grouping in the query. That might affect t hings.

 

[macleanb]

Perfect Norie - thanks for the speedy reply (worked )

 

[macleanb]

P.s. I have a long standing curiosity about your sig - whats the Peruvian connection (or shouldnt I ask)