What does this mean? 1

[Nancy2]

"SELECT * FROM adview WHERE 1=1 AND memid=11219 ORDER
BY ADID, positiontitle"

Can someone tell me what the WHERE 1=1 is doing? Of course no field named 1.

Thanks

 

[smedvid]

This could have been a test case that was hard-coded into the query to validate the design/results. Other than that, I don't see this doing anything. I believe you can remove it without harm. htwh Steve Medvid
"IT Consultant & Web Master"

http://users.erols.com/medvid/

 

[Nancy2]

Thank you! That's what I suspected.

 

[tlbroadbent]

"WHERE 1=1" always evaluates to true. Sometimes, when dynamically building a SQL statement with optional WHERE criteria, I will use WHERE 1=1 and then concatenate the other criteria. This may have been done for a similar reason in your example.

Example:

sCrit1="Col2=12"
sCrit2=""
sCrit3="Col5='Denver'"

SQL = "Select * From Table Where 1=1 "

If sCrit1 <> &quot;&quot; Then
SQL = SQL & &quot; And &quot; & sCrit1
End If

If sCrit2 <> &quot;&quot; Then
SQL = SQL & &quot; And &quot; & sCrit2
End If

If sCrit3 <> &quot;&quot; Then
SQL = SQL & &quot; And &quot; & sCrit3
End If

This example creates this SQL statement:

Select * From Table Where 1=1 And col2=7 And col5='Denver'

If all three criteria are blank the statement (Select * From Table Where 1=1) will return all records. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.