• GSquared (10/15/2009)


    One reason I worked it the other direction is that it gets rid of the functions in the Where clause. That's usually a good idea for performance. Probably doesn't matter in this case, but it's a good habit to be in.

    ah yes thats true 🙂 Functions on any column having an index is not suggested if you are looking for better performance

    ---------------------------------------------------------------------------------