General information
Category:
Coding, syntax & commands
> >>SELECT mytable
> >>SET FILTER TO
> >>alltrim(SUBSTR(ctitle,atc((substr(cname,1)),ctitle),len(cname)))=cname
> >
> >Do you have a tag on
> alltrim(SUBSTR(ctitle,atc((substr(cname,1)),ctitle),len(cname)))?
>
> No. Do you think that is the better way to do it?
most probably - YES
I would also try to simplify the expression and do this in stages
the later stages would be faster as you wil have a smaller sub-set of record to "work" on
commands like ATC etc. take longer time to evaluate than simple indexes
Arnon
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only