I need to use an SQL statement of the form:
"select firstname, middlename, lastname from tbl where lastname like 'carter' order by lastname, firstname, middlename DESC"
I have normal indexes on the three name fields and a metamorph index on lastname. This command, however, does not produce the expected results, either at the command line or with WebScript. I tried creating metamorph indexes on the other name fields (just for the hell of it) but that didn't help.
What could be going wrong here?
Thanks,
David
"select firstname, middlename, lastname from tbl where lastname like 'carter' order by lastname, firstname, middlename DESC"
I have normal indexes on the three name fields and a metamorph index on lastname. This command, however, does not produce the expected results, either at the command line or with WebScript. I tried creating metamorph indexes on the other name fields (just for the hell of it) but that didn't help.
What could be going wrong here?
Thanks,
David