Hello all



Can someone shed some light on reasons to use 1=1 in SQL clauses like
the following :



select *

from sg..mytable with(nolock)

where 1=1

and (1=2 or f1 like 'JK%')

and (1=2 or f2 in ('somevalue'))



Thanks






MS Sql Server LazyDBA home page