Hello

I am a novice shell scripting programmer, so please bare with me.

I have embedded a simple SQL statement into a shell script, which simply returns an integer (its a count (*) statement).

The result of the statement is then oputput to .txt file. So, the number could be 0, 1,2, 10, 50, 101 etc.

What I want to do is send an email if the number output into the .txt file is greater than 0. How do I check that the number output is 0, I thought about checking whether the file contained a 0, but I thought this may not work as it may also return a true value if the number was '10' or '100' etc.

Thanks