Learning SQL.question about modulo operator..

[sajdlz]

This is the exact quote from my book...

Modulo returns the integer remainder of a division.
Here are two examples:
5 % 2 = 1
6 % 2 = 0
The modulo operator does not work with data types that have decimals, such as Real or
Number.

It took me a little while to first figure out the function (math is not my strong point) but my question is how often does the need to use this particular operator come up? It seems to me that it wouldn't be useful in very many situations but then again.. I am still learning:)

Thanks in advance to any who can shed some light!

[blastradius]

The truth is you could use it a lot of or never again. It really comes down to the type of logic that makes sense to you. As well as the type of programming you are doing.

You can really get a way with using very little math if you have too. My suggestion is forget the syntax of how to do it but remember that you can do it. That way when you need it you can look up the syntax and use it. But who know your logic may always find another way to do it.

[sajdlz]

Thanks for the reply... I'll try to remember that it is there but don't think I will use it that much.. who knows though.