thank you for the suggestions. I have alot of db's and would rather do the foreachdb option, so that I don't have to query each db separately. TOO...

I wanted to ask Pat a question and the email he provided in the article isn't valid anymore. Pat are you out there??? Please post a new email address.....

sorry Elmer, I hit a button and it "SENT" and I wasn't done!! Let me continue....

results:

original input string = 'abc,123;nko9jh'

ID ...

Hi Elmer! I have a question for you. I love this fn, but I have a need to split out a semicolon delimited string...then split it out again...

Hi Gail...

as I was pasting in myquery, I thought about trying something first. In my query, I changed a straight INNER JOIN on the temp table to a INNER...

thanks you guys for all the input, I so appreciate it. What I have done and so far it is working, is that I have several if statements and...

ok, I am trying to go about this another direction....my thoughts are to find out what the data is I need and apply it to a variable and then use...

thank you Jeff...I am trying as we speak and will post when I get something that looks sane!!

thank you!

BOL is very unclear about being able to do weird stuff with a case in this case (no pun intended) being able to do a select within the case. ...

no dynamic SQL...

what I need is data that I am pulling straight from the table and then based on 2 parameters data about the location. they will pass in...

thank you for the clarification, I appreciate it!

thank you both!! I am off to fix the problem!! Have a great week! :hehe:

Ok, got it!! Thanks to both of you...I appreciate the help!!

ok, so now what db do I run this against so I don't get the error msg I spoke of????

Thanks again guys!!