>Hello all,
>what are the disadavntages of using functions like allt(), upper() in where clause of Select sql. I have been told that it is not good to write such funtions in where clause.
>Please help me what are the disadvantage of this functions in where clause?
>thankyou
>john still


Over head will be more. in turn it will be a bit slower. if u have large database, and Query gives large data , then u eperience the problem.