On 7/4/06, Richard Hartland <[EMAIL PROTECTED]> wrote:
The +asc in the order by is not being recognized as correct syntax. I am unfamiliar with using the + operator in this way - what does it do?
I guess drh made a typo in his previous email. That order by should probably be something like: ORDER BY +S.SortID ASC + in front of column name prevents any index you might have on that column from being used. That sometimes can be faster then using an index. -- Nemanja Corlija <[EMAIL PROTECTED]>
