>Hi
>
>I have a table with 82 fields .
>33 fields are numeric .
>
>In one record , yes in one record , i want know the name of fields , that value = 12 , for example .
>I spend a lot of time to see browse that record , because are 33 fields numeric .
>I want only know the name of fields , in one record that i tell , have the value that i tell .
>
>Imagine , Table 1 , Record 1
>
>Field1 = 12
>Field2 = 99
>Field3 = "Bill Gates"
>Field4 = .T.
>field5 = "Michael Fournier"
>field6 = 12
>field7 = 30
>field8 = "Claudio Lassala"
>field9 = 12
>...
>
>I want the result is : Field1 , Field6 and Field9
>
>Do you undsertand what i want ?
>Can you help me ?
>Thanks
If different fields contain related information, that's an indication that your table is, perhaps, not properly normalized. In other words, you would probably be better off putting the numeric data into separate records, in another table.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
