It's not a wildcard expression but you could use something like:

WHERE REPLACE(actualTime, '0', '') <> ''

or

WHERE CAST(actualTime AS INT) <> 0

The replace would result in any actualTime string containing only zeros to be a zero-length string. Although I have no idea on the performance of either of these on mass.

You might wish to consider changing the column definition to an INT and the check for anything that is not zero. I'm sure the performance of that would be better than any fuction performed in a WHERE clause.