I have a table, table1, with the field 'areacodeplustelephone'. This field
is of length 10. I created an index called 'areacode' that only uses the
first three characters.
Can I use this index in my select statement?
I tried this: select name from table1 where areacodeplustelephone =
330' -- no results
I tried this: select name from table1 where left(areacodeplustelephone,3) =
'330' -- got the results but slow...id didn't use the index
I'm I going about this the wrong way? Is there a better way than using the
"left" function?
Any help is greatly appreciated.
-bruce duncan