OSQL output stored procedure column formatting problem

Question

Viewing 3 posts - 31 through 32 (of 32 total)

You must be logged in to reply to this topic. Login to reply

nbryson SSChasing Mays Points: 659 More actions · Answer 1

Hi

One slight problem is that any fields that have a zero length char string are output as a space. I need this to not have a space.

Any Ideas

Cheers

Nickie

Sergiy SSC Guru Points: 110208 More actions · Answer 2

NULLIF(FieldName, '')

_____________
Code for TallyGenerator

nbryson SSChasing Mays Points: 659 More actions · Answer 3

SSChasing Mays

Points: 659

May 29, 2007 at 5:53 am

That did the trick.

Cheers