Jump to content

Select between 2 Negative values


Recommended Posts

HI, Well maybe I'm going mad but I have a simple database , one of the fields is a negative value which is out gps latitude, well in NZ it is. :)so I have a database of values between -35.000000 thru -45.000000I want to select values BETWEEN -36.5000 and -36.55000 ( for example, ) but I get 0 rows rurned, if I usethe same search string for a positive value like longitude it works fine, so what is the secret to sel;ecting records Between 2 negative values ( which are small intergers)I really cant find the answer to this Ive looked high and l,Can anyone help.

Link to post
Share on other sites
HI, Well maybe I'm going mad but I have a simple database , one of the fields is a negative value which is out gps latitude, well in NZ it is. :)so I have a database of values between -35.000000 thru -45.000000I want to select values BETWEEN -36.5000 and -36.55000 ( for example, ) but I get 0 rows rurned, if I usethe same search string for a positive value like longitude it works fine, so what is the secret to sel;ecting records Between 2 negative values ( which are small intergers)I really cant find the answer to this Ive looked high and l,Can anyone help.
I have the fields set as integers, any help really appreciated.
Link to post
Share on other sites
I have the fields set as integers, any help really appreciated.
I could be mistaken, but if they're integers then there won't be any values between whole numbers. An integer column won't store a value like '35.00000', it'll truncate it and store '35'. You can store a negative number, i.e. '-50', but not '-50.003'.
Link to post
Share on other sites

Yes, integers are whole numbers, to it is not possible to have any values between -36.50 and -36.55.

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...