Which SQL Operator to use and operator semantics

I am unsure which of the SQL operators to use in querying. Should I use jc_compare exclusively,


or is there any advantage to using jc_contains, jc_equals, jc_tanimoto?


The main difference I think is that jc_compare allows a lot more customization of the query. Is that correct?





I am also not 100% clear on what column to specify when using a column to specifiy the target structure.





I am currently using





jc_contains(cd_smiles, '" & vchQuery.Value & "') = 1





for a substructure search.


Which column is it best to specify? Is a particular column more efficient than another?





Cheers





Paul

Quote:

I am unsure which of the SQL operators to use in querying. Should I use jc_compare exclusively, or is there any advantage to using jc_contains, jc_equals, jc_tanimoto? The main difference I think is that jc_compare allows a lot more customization of the query. Is that correct?

Correct!

Quote:

I am also not 100% clear on what column to specify when using a column to specifiy the target structure. I am currently using jc_contains(cd_smiles, '" & vchQuery.Value & "') = 1 for a substructure search. Which column is it best to specify?

It is a matter of which operator type you expect to use: jc_xxxx vs jc_xxxxb . (See http://www.chemaxon.com/forum/ftopic1605.html) For jc_xxxxb you obviously need cd_structure, for jc_xxxx you need cd_smiles.

Quote:

Is a particular column more efficient than another?

No difference in efficiency/performance.





Cheers


Peter

Thanks for that info!