for example: get all value of PITag where PITag > 0 between '*-h' and '*'@
I am not sure exactly what you are asking. If you want to get started with writing SQL queries to use with PI ODBC, you should take a look at the query compendium in SQL Commander which is documented here.
I regret that I was not able to help Mellisa Taylor; I find it so difficult to find the document on SQL query…
Also, document on PI Table/View, such as ..[picomp2], etc. which explains what and when to use them.
Mellisa (the customer) has gotten what she need.
Retrieving data ...