FW: MI - Find odd or even numbers in a column

[Serge Bedard]

                        
                        Try this:

                        Select *
                        From YourTable
                        Where YourColumn Mod 2 = 0
                        Into Even

                        Select *
                        From YourTable
                        Where YourColumn Mod 2 = 1
                        Into Odd

                        Serge
                        QA dept.
                        GeoCom TMS inc.


                                -----Original Message-----
                                From:   David Reid
[mailto:[EMAIL PROTECTED]] <mailto:[mailto:[EMAIL PROTECTED]]> 
                                Sent:   Monday, September 04, 2000 7:17 PM
                                To:     MapInfo-L
                                Subject:        MI - Find odd or even
numbers in a column

                                Using "Select" how would I go about
selecting odd or even numbers in a
                                column? I thought I had figured out the
syntax but it didn't work.


                                Thanks list,

                                Dave

        
----------------------------------------------------------------------
                                To unsubscribe from this list, send e-mail
to [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>  and put
                                "unsubscribe MAPINFO-L" in the message body,
or contact [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]