I am trying to do a formula in sql that I have in excel. I've cut it down to the very basics. All I want to get is LOG(0.05).
In excel I get -1.3 and in T-SQL I get -2.99.
The only difference I can think of is that in T-SQL the variable is a float.
Can someone help me or have I completely lost it?