Well, at least that's a polite way to "bump" your post... 😉 This isn't "instant...

Oh, sorry... yes, your query is the ticket... mine is wrong.

Perhaps, something like this...

select first_name

,last_name

,government_id

from people

where government_id like '[0-9][0-9][0-9]-%'

... and no... I don't recommend using two loops 😛

Marcus Farrugia wrote:

---

can I humbly ask someone to show me how to use any of the solutions using the data structure from my tables. I know this is asking...

I know what your meant, but just so you know... the term "wise guy" in many English speaking countries is usually considered to be a fairly...

...almost forgot... the "words" you're looking for are "Parsing a delimited column".

If you really want help, refer to the following article...

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Ummm... what's not in Books Online is the fact that the DATETIME datatype is a "fixed position float". I know... sounds contrary... what I mean is that DATETIME datatypes...

The addition zero is coming from the fact that it's automatic code... it figures out that the "Page1" entry is 5 characters long and uses that asthe length for all...

Thanks David... appreciate the explanation...

Yeah, I figured the Stuff and Group By out for the single table application... just didn't understand it for the two table application. Now, I...

Heh... not to worry, Grant... I have a target on my desk, right next to my coffee cup, that says "Pound head here, then read the post again." I've...

Like I said... use the code I just posted... it takes the CHAR(32) into account...

Brett,

Obviously, a couple of us have run into the problems associated with "Sequence Tables" such as you've described... if you would, please, generate the table creation for your sequence table...

Heh... feed the vendor a nice juicy pork-chop... with a sling-shot! 😉