Yeah, a bad habit it may be. That said, I had not seen an index on bintoc() fail neither, until yesterday
Seems like I may be in for a change of habit after all, (I'm assessing the changes currently), until the index on Integer fails one day
Still, I wonder, if bintoc() index fails under certain circumstances, there's a probability that an integer index will just as well. I'm just curious as to why and under what circumstances
>Gregory,
>
>It's a bad habit. *g*
>
>I've never seen an index on an integer column fail to work. I routinely index on integer, date, datetime and numerics. I don't have a single table where a double column exists.
>
>>It's a habit. I've always stayed away from indexing on Integer, Date, DateTime, Numerics and doubles
>>
>>If bintoc() sometimes, not always, fails on views and cursors and not on tables (yet), who says that an index on an integer won't
Gregory