CELKO (9/13/2012)

---

Which is why I took the time to go into details with...

CptCrusty1 (9/13/2012)

---

Here is why I asked, the sample data you posted above has 1 row where the Legal column has a "record" with 25 columns based on the column delimiter...

Anybody have any ideas? I can't find much myself.

Wrong thread....

Anybody have any ideas? I can't find much myself.

Just so you know where my mind id currently going, even if it isn't the right direction:

with InitialData as (

select

InitData

from

(values

('1994-00000001|12/27/1993 12:00:00 AM|01/03/1994|SL|16|33|STATE TAX LIEN|2|:OPR:1169:250|TEXAS STATE OF|KFC...

CptCrusty1 (9/13/2012)

---

Lynn, In this case, yes there are always 13. The data is from a State Government. A different state might have 12 or 9, but...

matt.newman (9/13/2012)

---

Dah Blame Area (until proven otherwise)?

I actually got the additional help after reading off the post replies from here. I still don't have anything "rock solid" (to present or...

ScottPletcher (9/13/2012)

---

Lynn Pettis (9/13/2012)

---

ScottPletcher (9/13/2012)

---

but if you are creating a table of product groups (<'BK','Books'>,<'SH','Shoes'>,<'BG','Bags'>) etc.. I would put an ID field on that and use that instead, otherwise if...

I thought I better ask, you do know what DBA stands for don't you?

Are there always 13 columns in the data for Legal? Looking at one of the data rows you provided it doesn't appear to be the case.

CptCrusty1 (9/13/2012)

---

Here's the RAW data:

Doc Number|Document Date|Rec Date|Book|Vol|Page|Doc Type|# of Pages|Related|Grantor|Grantee|Legal|Amount|Image ID

1994-00000001|12/27/1993 12:00:00 AM|01/03/1994|SL|16|33|STATE TAX LIEN|2|:OPR:1169:250|TEXAS STATE OF|KFC NATIONAL MANAGEMENT CO|::::::::::::FOR RELEASE SEE OR VOL 1169 PG 250 2/23/94 ...

ScottPletcher (9/13/2012)

---

but if you are creating a table of product groups (<'BK','Books'>,<'SH','Shoes'>,<'BG','Bags'>) etc.. I would put an ID field on that and use that instead, otherwise if someone decides they...

CELKO (9/13/2012)

---

As an aside, some other SQLs have special optimizations for the IN (<expression list>) predicates. Most of the time,...

Would really need to see some sample data (just a couple of rows that emulates the actual data) and the expected results based on that sample data.

From what you posted,...