i have 2 functions:

f1() - always returns 1

and f2() - with loop: "while true"

when I wrote:

if (dbo.f1() = 2) AND (dbo.f2() = 2) select 1 else select 2

there was...

ok, thanks.

but... I expected that there isn't calculated all boolean logic in 1., - for example: if COND1 is false, the rest of expression...

thanks

but I red, that AND conditions are evaluated them from left to right in the order they are written - thats mean, that every...

function compares 2 strings, and returns 1 if they're similar. it's like Levenshtein Distance, but for max difference between 2 words = 1 (O(n), not O(n^2)).

it is possible, that...