Okay worked that one out, I can use CASE.

Thanks again.

Sunil

Okay one more question on the subject. What if, instead if SHP_ZIP having NULL values, it had '0000' in each entry where no shipping zip existed. Then the ISNULL function...

Hi guys,

Yes you are all right, sorry I got the nullage the wrong way round!

But the ISNULL function is exactly what I was looking for, many thanks for all your...

Excellent tip, thanks!

Brilliant, thanks Lewis.

Sunil

That's fab Nabha, very useful indeed.

Many thanks.

Sunil

Many thanks for both your replies.

I've made a quick test table and tried it with Mark's method, it worked a treat.

It was definitely useful reading up on EXISTS/NOT EXISTS on...