>Hello,
>
>I have an SQL query where I need to use strtran() in the where clause:
>WHERE STRTRAN(cname,' ','') = MyVar
>
>This slows down the process a lot!
>Is it possible to optimize this query? I have alrdady an index on STRTRAN(cname,' ',''), but this does not change the performance.
>
>Any help is highly appreciated!
An index on strtran(...) is virtually useless, since it is of variable length. Any decent VFP index has a fixed length. Perhaps padr(strtran(...)) will achieve better results.
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)