left(codes,1) = '1' ias not optimizable; either add an added tag, or use code = '1'
and adjust the SET ANSI setting to match only up to the shorter expression, so that it becomes optimizable.
>The other selects select codes = 2 and then codes = 3.
>
Same suggestion.
>This table has 4 indexs and I'm not sure how to tell if one indexes the name field. How can I tell what an index indexes?
>
SYS(14) handles returning the index expression of a tag or IDX style index.
>Thanks,
>Sunshine
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater
NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC
The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys