>I have a segment of code that before calling SEEK() it checks if the current index tag is of character type. So what I do is the following:
>
>
>if type(tag()) = "C"
> SEEK("something")
>endif
>
>
>An issue I ran into is when the index key is something like
>UPPER(SUBSTR(myfield,1,20)), the type(tag()) returns "U". I can change the code above to check that the Type(tag()) is not "L" or "N" and then call SEEK(). But I am thinking that perhaps there is a better approach.
>
>If you can suggest something alternative, I would appreciate it.
If you want to check for the type of index key expression then you could use:
VARTYPE(EVALUATE(KEY()))
Edward Pikman
Independent Consultant