Search results for query: *

I just wanted to thank all three of you again for your help. With a little tweaking, your solutions worked like a charm. Thanks again!

Oops, ignore the part about your "first reply." I just realized you are multiple people. :)

I think that's what I need, I'd just like to ask a couple questions to understand this a bit better. Even if productfinish is declared as a char(1), "2345 LIKE %5%" would evaluate to true (ignoring the cast for simplicity)? Likewise, "2345 LIKE %3%" would also be true? For some dumb reason...

Thanks, that first part is perfect. Exactly what I was looking for. My goal is really to pass @parmFinish in as a string, and then iterate through it, pulling out each character and using it as its own parameter. I would pass them in as individual variables, but there could be three finishes...

Just to clarify, all I really need to know how to do is the following, but my syntax is just all screwy. Select itemNumber from itemMaster where if @parmGroup <> "N" (N = none specified ie all) begin itemMaster.Group = @parmGroup if @parmCategory <> "N" begin AND...

Hello, I've got a MS SQL procdure to write that i sa bit above my head. Any help would be greatly appreciated. I am working on this for a web site I'm building, and the DB guy at the company I'm working for works mostly in RPG, so it's up to me. I'm really only working with one table in this...