Is this what you need?
IF Len(REPLACE(@s,'0','' )) > 0
SELECT LEN(REPLACE(@s,'0','' ))
If everything seems to be going well, you have obviously overlooked something.
Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]