Check nr of fractional digits

PHOTO EMBED

Thu Jul 01 2021 13:46:30 GMT+0000 (UTC)

Saved by @Bartcw89 #sql

DECLARE @power DECIMAL = POWER(10, /*Nr*/);
SELECT Value
FROM (SELECT /*Column*/ AS Value FROM dbo./*Table*/) AS Focus
WHERE ROUND(Value * @power, 0, 1) <> (Value * @power);
content_copyCOPY

Searches decimal values with a specific amount of fractional digits.