>Assuming SET EXACT is ON
>Will this effect my filters ?
>ie: Set filter to x.city="Houston"
>
>Also will this effect my LOCATE and SUM statements? I do know that it deos not effect my SQL Select.

Setting EXACT ON will effect your filters and LOCATE and SUM statements and most other functions you call. It is only scoped to your current data session though.

>
>Finally - what is the difference between:
>CALCULATE SUM
>and
>SUM
>

CALCULATE SUM and SUM do the same functionality. However, CALCULATE SUM allow you to select an alias whereas SUM only uses the current alias selected.

Hope this helps,