>When indexing on a date field, is it better to use the "DTOC(ldField,1)" or just "DTOC(ldField)"?
It is best to just index on the date expression itself:
Index on ldfield tag ldfield
Use DTOC(,1) when you have to concatenate your date expressions with other character expressions. Otherwise, depending on your data format, you could have October, November and December coming before February.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao
