Ok guys, I really appreciate everyone’s help on this. I sure did not expect a search page to become such a data base nightmare. I...

I can see where this sproc could become quite large that is why I posted it to see if someone had a better way. But I don't see how you...

Thanks for the help Vladen. I see the flaw now. I have went back to my original train of thought and came up with this sproc that works but seems...

David, I have been working with the script that you showed me and it was working great until I realized that I was supplying the itemID as part of the...

Thanks David, you have been a big help. As far what Joe was saying I will give a little more information so we can decide if I am complete idiot...

Wow you guys ROCK!! That worked like a champ and much simpler than the path I was heading down. Yes Vladen the RFloat table has a min and max value...

Thanks you for yor suggestion David, but I think I left out an important part. Yes each attrID can exist in only one of the three atribute tables, but i...

Sorry if my previous post was confusing.The attributes table holds many types of attributes for each item. Example: the item AAA has 3 different attributes in the attributes table one...