>and an index tag using the expression
>AGENTCODE + STR(CTRL_NUM,6)
>
>
>(1) Are there any settings which would make a query such as
>SELECT * FROM myTable ;
> WHERE agentcode = "XXXXXX"
>
>be optimizable??
>

In addition to what Barbara said (adding a tag for AgentCode), you can also optimize this query by changing the WHERE clause to:

WHERE AgentCode + STR(CTRL_NUM,6) = "XXXXX"

Make sure SET ANSI is OFF, if you do it this way.

Tamar