I have a field in an Access database table that holds a decimal (9,2) - dollars and cents. I need to analyze only the records where the cents are greater than .00. I have tried splitting the data field but am unable to identify the correct SQL query commands to do this - any suggestions? I have tried the split() function, but no luck. Any advice will be greatly appreciated. Thank you
TLJ232
in SQL
Posted
I have a field in an Access database table that holds a decimal (9,2) - dollars and cents. I need to analyze only the records where the cents are greater than .00. I have tried splitting the data field but am unable to identify the correct SQL query commands to do this - any suggestions? I have tried the split() function, but no luck. Any advice will be greatly appreciated. Thank you