Re: Question on Proper Use of EXISTS

This wouldn't be a good thing to do if the select statement might return more than one row. If it does you are only interested in the fact wether or not one or more rows are found or none are found. This select statement tells you too much (the exact number of rows). A better solution would be to declare a cursor and fetch or use an exists statement. Received on Sat Mar 31 2001 - 13:40:08 CST