byronmunya
Programmer
SELECT cast(Freight01 as integer)as Freight01, PPeriod FROM "HistoryHeader" WHERE Freight01 >= 89512 and Freight01 <= 100000 order by freight01 desc; This query returns nothing
But if I change it to this "SELECT cast(Freight01 as integer)as Freight01, PPeriod FROM "HistoryHeader" WHERE Freight01 >= 89512 and Freight01 <= 99999 order by freight01 desc;" it works
Need help why it doesnt work
But if I change it to this "SELECT cast(Freight01 as integer)as Freight01, PPeriod FROM "HistoryHeader" WHERE Freight01 >= 89512 and Freight01 <= 99999 order by freight01 desc;" it works
Need help why it doesnt work