This might not be the best place to post this because it is getting too asp instead of SQL but its worth a try 🙂

When accessing data from a data base I try to test whether a value is less than another to move on to a further step. I have a value license, startEx and endEx.

If I try:

if license > startEx then....

the code works fine, but when I try endEx it doesnt work. eg.

if license < endEx. I have tried just chucking in an integer of the same value of what endEx should:

if license < 6.... and that works. I have printed endEx to the screen and it comes up as a number. I have checked the database and it is stored as an Int. I have no idea whats wrong. Any ideas?