Comparing two fields over a certain percentage

[OasisChurch]

Hi,
Is there a way in T-SQL to compare two fields over a certain percentage?
EX: SELECT [ACCOUNT NO] FROM TABLE1 WHERE VALUE1 >= %5 OF VALUE2

Weird Huh?

thanks in Advance!!
--scotta

 

[MeanGreen]

Just multiply your comparision by .05 to get 5 percent of it. Example:

SELECT [ACCOUNT NO] FROM TABLE1 WHERE VALUE1 >= (VALUE2*.05)

Hope this helps.