Hi John

If you really mean 'contains S' then why not use something like INDEX ON yourfield WHERE AT('S',yourfield)>0 TAG SFILTER ?? Will do the trick nicely.

If you mean 'starts with S' you can use INDEX ON XX WHERE yourfield='S' TAG SFILTER


>No I really mean an index as in "index on this field". I have to pass an index that will only provide the data that contains an "S" . I just can't figure out how I can do this. I'm hoping that there is someone that has figured out a way. I know I can use substr and other functions to filter or select the information in the where but I need to create an index for the table. The table and index are passed to a program that will use it to get only the rows that contain an "S".
>
>John