Hmm..have to see if I can figure out how to do that...I've done 99.9% of my SQL using pretty standard (but creative!) queries from VBA, MS Access, etc, and have...

The point is, I'm applying one calculation to EVERY vendor in the main vendors table...inventory value divided by sales value, to get what percentage of inventory has been sold.

BUT

If the...

Thanks for the pointers, Lynn!

[font="Courier New"]Parent-Child Mapping Table:

ParentChild

32256504

32256505

32256666

32257777

etc…

Vendors Table (some Vendors here are NOT in parent-child mapping table):

Vendor IDSoldTotal Inventory Value

1011 $291,393.98 $3,353,695.20

2022 $29,308.59 $65,607.55

3033 $684,942.09...

Wonder why it's even on that menu anyway, then...??

Thanks, Kingston, I'll give that a try...

Cool, I'll try playing with that.

What I'm trying to do is create a Stored Procedure that will take a string of text as a parameter, and then search all the...

Hi, Lowell!

How do you actually call your code snippet that ignores text inside comments?

--Brian