<div>
Agree with bhess1 - your condition ['All'=lower('all') will never be true. You can also optimize some clause in the where clause, so you query can run faster: <br />
T2.&quot;ITMCAT&quot; in ('D') will run faster if it written as<br />
T2.&quot;ITMCAT&quot;='D'<br />
The same is valid for:<br />
T2.&quot;ITMEDT&quot;&gt;=20010101 and T2.&quot;ITMEDT&quot;&lt;=20011231 <br />
It will become:<br />
T2.&quot;ITMEDT&quot; between 20010101 and 20011231 <br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />

</div>


Agree with bhess1 - your condition ['All'=lower('all') will never be true. You can also optimize some clause in the where clause, so you query can run faster:
T2."ITMCAT" in ('D') will run faster if it written as
T2."ITMCAT"='D'
The same is valid for:
T2."ITMEDT">=20010101 and T2."ITMEDT"<=20011231
It will become:
T2."ITMEDT" between 20010101 and 20011231









<div>
Thanks...much appreciated!!!
</div>


<div>
<div class="content wysiwyg-content">
Is &quot;All&quot; a keyword in SQL? &nbsp;I have this WHERE clause:<br />
<br />
SELECT T1.&quot;Descr&quot; c1, T2.&quot;ITMSCP&quot; c2, T2.&quot;ITMITM&quot; c3, T2.&quot;ITMCBL&quot; c4, T2.&quot;ITMSTS&quot; c5, T2.&quot;ITMTYP&quot; c6, T2.&quot;ITMNME&quot; c7, T2.&quot;ITMCRD&quot; c8, T2.&quot;ITMPHN&quot; c9, T2.&quot;ITMEML&quot; c10, T2.&quot;ITMDTE&quot; c11, T2.&quot;ITMEDT&quot; c12, T3.&quot;ALSCDE&quot; c13, T4.&quot;ICTNME&quot; c14, T4.&quot;ICTCOD&quot; c15<br />
<br />
FROM &quot;ACCOUNT&quot; T1, &quot;KITTRAK&quot;.&quot;dbo&quot;.&quot;ICTMST1&quot; T4, (&quot;ITMMST1&quot; T2 LEFT OUTER JOIN &quot;dbo&quot;.&quot;ALSMST1&quot; T3 on T2.&quot;ITMCMP&quot;=T3.&quot;ALSCMP&quot; and T2.&quot;ITMITM&quot;=T3.&quot;ALSITM&quot;)<br />
<br />
WHERE T2.&quot;ITMCMP&quot;=T1.&quot;AccountID&quot;<wbr /> and T2.&quot;ITMCAT&quot;=T4.&quot;ICTCOD&quot; and ('All'=lower ('all') or T2.&quot;ITMITM&quot; like 'All%') and T2.&quot;ITMSCP&quot; in ('LAN') and T2.&quot;ITMEDT&quot;&gt;=20010101 and T2.&quot;ITMEDT&quot;&lt;=20011231 and T2.&quot;ITMCAT&quot; in ('D')<br />
<br />
ORDER BY 2 asc, 14 asc, 3 asc, 13 asc<br />
<br />
<br />
Any ideas? &nbsp;Can't seem to understand.
</div>
</div>


Is "All" a keyword in SQL?  I have this WHERE clause:

SELECT T1."Descr" c1, T2."ITMSCP" c2, T2."ITMITM" c3, T2."ITMCBL" c4, T2."ITMSTS" c5, T2."ITMTYP" c6, T2."ITMNME" c7, T2."ITMCRD" c8, T2."ITMPHN" c9, T2."ITMEML" c10, T2."ITMDTE" c11, T2."ITMEDT" c12, T3."ALSCDE" c13, T4."ICTNME" c14, T4."ICTCOD" c15

FROM "ACCOUNT" T1, "KITTRAK"."dbo"."ICTMST1" T4, ("ITMMST1" T2 LEFT OUTER JOIN "dbo"."ALSMST1" T3 on T2."ITMCMP"=T3."ALSCMP" and T2."ITMITM"=T3."ALSITM")

WHERE T2."ITMCMP"=T1."AccountID" and T2."ITMCAT"=T4."ICTCOD" and ('All'=lower ('all') or T2."ITMITM" like 'All%') and T2."ITMSCP" in ('LAN') and T2."ITMEDT">=20010101 and T2."ITMEDT"<=20011231 and T2."ITMCAT" in ('D')

ORDER BY 2 asc, 14 asc, 3 asc, 13 asc


Any ideas?  Can't seem to understand.

&quot;ALL&quot; keyword in WHERE clause

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

&quot;ALL&quot; keyword in WHERE clause

"ALL" keyword in WHERE clause