I am working for a bespoke application provider and am stuck with an SQL query I am trying to write.
I only have basic to intermediate level SQL knowledge and the main issue I have is that the application is BDE/Paradox SQL based so some of the standard SQL queries that would work in MSSQL do not function.
I want to select all items from a table where the values in the relevant column have more than 4 decimal places but nothing I can find will work due to the limitations of the SQL database.
I have the ability to build multi-stage queries using answer tables to refer back to where necessary but am stuck at an empass on how to write it. Can anyone help me?