Net.data Macro/SQL SELECTIONS

I currently have the following steps in the browser selection. Each step executes it own SQL select/sort command, and essentially displays data in the same output format.

Top of Form 1

PICK the number of the SEARCH method:
1=Gage_ID____
2=Type_______
3=Range______
4=Location____
5=Cert_Number
6=By_Cal.Date
(THEN click Submit)

How would I go about creating say only ONE sequel statement, then having the operator choose their various sort fields, then fill the ONE SQL statement accordingly. Basically - how to do simple substitutions into a SQL statement in net.data.
Bottom of Form 1

Don F. Cavaiani
IT Manager
Amerequip Corp.
920-894-7063

"It's amazing what you can accomplish if you don't care who gets the credit." Harry S. Truman