>I am trying to index a view with the following:
>
>Index On textsem+Right(Alltrim(department),1)+courseid+section+Type Tag dep_type Additive
>
>it doesnt seem to work.
>When I do one or may be two fields at a time it works fine but when i try to do the previous code it just does not index the view.
>
>any would certainly be appreciated
>Dave
What do you mean, "does not work" - error messages, or incorrect results?
The alltrim(department) part should be handled with care. By itself, it produces a variable-length expression. In combination with right(): what happens if department happens to be blank? Try to use an expression that will always give you the same length, for instance:
padl(department, 1).
HTH,
Hilmar.
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)
