SQL search

[jda]

I have a table with 19 records. One of the fields is "propertyName", 
where I store the name of a variable, and the other field can contain 
the various values.

This search

   myDatabase.SQLSelect("select varCharField from misc where 
propertyName='groupName' ORDER BY varCharField"

returns all 19 records, even though only one of them has a 
propertyName of 'groupName'.

What is wrong with the select statement (or is this a bug in 2.0)?

Thanks,

Jon