# 273 Non-Optimized Where Clause in SQL SELECT Statement Causing an Access Violation

---

When last line is changed to liik like the following:
t2.FileID+'1'
t2.FileID+'1*'
t2.FileID="1%'
t2FileID="22"
then I try to open the query, Delphi goes into loopy land and I eventually have to use Close Program to kill it. There is occasional disk access. There are only four reccords in each table. Sometimes I get AVs before it fades out, sometimes not. I also tried replacing the "=" with "LIKE" with the same results. I tried using double quotes, and get repeated AVs in DBISAMDB..BPL, but the program stays alive.