Thanks Sean that's what I was needing!

Mike-I just realized the query is substring the first 7 characters of the SecondString. That string will be variable in length.

Mike.. the parts are not fixed length.

Your first select is returning great results but the occasional '~' is on the end of some records.

B005739997706~

I added a replace on...

I finally hit my search correctly... Jeff Moden already posted an amazingly simple solution!

http://www.sqlservercentral.com/Forums/FindPost452711.aspx

Thread closed....

deepika.sharma-632099 (2/17/2008)

---

my issue got resolved by following step:

To allow the network transaction, you must enable MSDTC. To do this, follow these steps: a. Click Start, and then click Run....

Here is my final script:

UPDATE A

SET A.PropertyValue = 'False'

FROM UserPropertyData A

INNER JOIN

(

SELECT c.UserID FROM UserPropertyData C

INNER JOIN

UserList d

ON c.UserID = d.UserID

WHERE d.IsCompany = '1' and c.PropertyID = 7 and c.PropertyValue...

haha.. it's like pulling teeth from me huh?? thank you so much for your patience Gkhadka! I greatly appreciate it.

Gkhadka (7/16/2009)

---

Here this should work.........

CREATE TABLE #TEST ([UId] int, PId int, PV varchar(10) )

INSERT INTO #TEST VALUES

(33138, 9, 'True'),

(33138, 8, 'False'),

(33138, 5, 'False'),

(33138, 7, 'False'),

(33130, 9, 'True'),

(33130, 8, 'False'),

(33130, 5,...

Well there are 166,443 rows that will need to be updated based on PropertyID equaling 7 and the PropertyValue equaling False.

Rich96 (7/16/2009)

---

Okay I'm stumped. I need to update a value in the same table but different record based on the UserID column. I have about 35,000 records...

Jeff & Christopher.. thanks so much for the feedback! Looks like I have some reading to do.

I'd be willing to learn anything new if you are willing to throw a script my way. There potentially could be 29 codes per record but I chose...

I've actually added more "codeN" columns (5 total).. here is my final script -

declare @t table(CIF varchar(7), ACCTNO numeric(16,0), SSNO numeric(9,0), CODE int)

insert into @t

SELECT LN.CIFNO, LN.ACCTNO, CF.CFSSNO, LNS.LNSICD

FROM DB2_ODBC.JHASVR.DATSRM.LNMAST...

-Jeff

Unfortunately I'm dealing with a 3rd party vendor that could not process the normalized table. In fact I've had to convert all my alphanumeric fields to ASCII..

Thanks so much.. that's going to do it for me!