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