Case Insensitive Index (was Re: Three cheers for 4gl's CONSTRUCT)

MikeT300 (miket300@aol.com) wrote: : >>How about: : >> : >>OPTIONS CONSTRUCT CASE INSENSITIVE : >> : >Why not the following: : > : >CONSTRUCT string_var ... : >END CONSTRUCT : >LET string_var = UPSHIFT(string_var) : > : >This should do whatever you need because table/column names are already : >case-insensitive. : Thanks for the solution, but unfortunately your suggestion won't : accomplish what I want. : Its true that column names are case insensitive, but your solution will : only match char values : that are upper case. I want to be able to match char strings REGARDLESS : of the case of : the characters in the strings in the table. : <example with smith, SMITH, and Smith deleted> There's no way to make construct do a case insensitive search...not without using all possible cominations of upper and lower case in the constructed query (ie SM* Sm* sM* and sm*) This list would becomes 2**chars long. A better solution would be the ablility to create a "case insensitive" index on a field, so that the values in the index are all upper case for query purposes, but the field values in the .dat file are mixed case. Then a query for SM* would bring back all three Smith records.