returning only even number values from a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am in need of a bit of assistance in returning only even numbers from a
field. Example: (Select bldg_no from table where bldg_no = 'even number') -
I believe it to be a mod function but I can't seem to get the correct syntax
for the SQL to return it. Any help would be tremendously appreciated.
 
I used following syntax and it works for me.

SELECT * FROM
mytable WHERE (fldname mod 2) = 0
 
Back
Top