Hi Raza,
You either create an index tag on substr(itm_numb, 1, 3) (or left(itm_numb, 3) and change the where to reflect this) or if you already have an index on itm_numb you can just remove the function altogether and leave it as itm_numb = 'STI' (you need to have SET ANSI OFF)
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
