>I need to index on a string field. I'd like the index to index on all items that have a "S" as the leading char but must not include anything that does not have the "S". As in "S12345" would be Ok - "12345" would not be OK. I need to have a index because another program requires that I pass an index to find the right items (I don't have source code for the program).
Do you mean a filtered index? In this case, the filter condition would simply be
... FOR left(MyField, 1) = "S". A filtered index will only include items that match the criteria.
>
>Anyway I can't figure out how to create this index.
>
>TIA
>John
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)