Substituting a zero value

[Nsan]

I run the following:

select custname, count(custid) as CUST

Produces the following:

Brandon 0
Greg 0
Sam 5
Chris 0
Steve 2
Jordan 0

How can I substitute the zero values for a blank space?

Thx

 

[SajidAttar]

Try this . .

select custname, case count(custid) when 0 then '' else count(custid) end as CUST . .

Regards,


"There are no secrets to success. It is the result of preparation, hard work, and learning from failure." -- Colin Powell

 

[vongrunt]

FYI count() returns integer, '' is a string.

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[Nsan]

Thanks for the suggestion, but no change


Same results


Brandon 0
Greg 0
Sam 5
Chris 0
Steve 2
Jordan 0

 

[gmmastros]

Like Vongrunt suggested, you need to treat either case to return a string.

select custname, 
       case count(custid) 
          when 0 
          then '' 
          else Convrt(VarChar(20), count(custid))
          end as CUST

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom