I'm currently in the process of converting a PHP system using MySQL 

over to an ASP system using SQL Server 7.  It is a large search system 

that allows you to search for stores near your location as well as 

important marketing and demographic data such as population, percentage 

of people with some schooling, householders, local businesses and the 

like.  It allows for range searching on some fields (as well as 

"roughly" matching criteria: more range searching) and exact searching.  

It also allows multiple states, areas, local businesses and the like to 

be selected.



    I've normalized my database to include a one to many relationship of 

a site to a local business, retail information, etc.  All in all I feel 

it is an ideal system/environment to work with at this point.



    Now comes the part of actually conducting the search.  There are 

ALOT of fields to deal with, and alot of choices to be made (is it a 

in-between search, rougly, or exact?  Did they submit criteria for 

this?).  The submitting form's field names do not match my table's field 

names so I will need to do some translation.



    My question is: does anyone have experience with this or has a 

really good idea on going about this?  Something that I may have missed. 

 At this point I'm going to SELECT CASE against alot of stuff and build 

the SQL string as I go.  Any thoughts?



    I'm currently using VBScript in an ASP page to process the search.  

I can use JavaScript if necessary.  I cannot write any additional 

libraries or components because I will not have that kind of control 

over the production environment.  I can write stored procedures.  I'm 

experienced with Regular Expressions.  In fact, if someone wants to be a 

ninja and see what they can suggest with XML and converting it to SQL 

with XSLT, I'm all ears.



    Thanks!



- Chuck