Adam,

Yes and no.

Because the Val2 and 3, may be diffent lengths, that I will just do an update from the mail server based upon the id field.

My head is tired.

Many...

Adam,

Currently Have

MAPI:{East, Greg}EX:/o=val1/ou=val2/cn=val3/cn=val4

Need to make

val2=Data Center val3=Recipients

Keeping val1 and 4 the same

Easier?

Doug 

My latest changes have done loads of good, but I found another error.

Script:

select "_EMAILID_",(substring([_EMAILID_],1,charindex('EX:',[_EMAILID_])- 1)+

'EX:/o=Company/ou=Data Center/cn=Recipients/cn='+

substring([_EMAILID_],charindex('s/cn',[_EMAILID_])+5 ,len([_EMAILID_])))

--(substring([_EMAILID_],charindex ( '/ou',[_EMAILID_])+1 ,len([_EMAILID_])))

from _CUSTOMER_

where "_EMAILID_" like 'MAPI%' and

"_INACTIVE_:"=0

Glitch:

Current Value:  MAPI:{Vaughn, Rickey}EX:/o=Company...

Adam,

Current Sample Data:

MAPI:{Cortez, Jorge}EX:/o=Company Name/ou=Data Center/cn=Recipients/cn=JCortez

MAPI:{Slafka, Andrew}EX:/o=Company Name/ou=Data Center/cn=Houston - WLY/cn=ASlafka

MAPI:{Elliott, Kenneth}EX:/o=Company Name/ou=Houston 2/cn=Recipients/cn=KElliott

MAPI:{Murphy, Reginald}EX:/o=Company Name/ou=Houston 2/cn=Recipients/cn=RRmurphy

MAPI:{Moody, Rice}EX:/o=Company Name/ou=Houston 2/cn=Recipients/cn=RMoody

MAPI:{Tomlin, Lionel}EX:/o=Company Name/ou=Houston 2/cn=Recipients/cn=ltomlin

MAPI:{Desoto, Lynn}EX:/o=Company Name/ou=Houston WLY/cn=Recipients/cn=LDeSoto

MAPI:{Whitmire, Jeff}EX:/o=Company Name/ou=Data Center/cn=Recipients/cn=JDWhitmire

MAPI:{Bauer, James}EX:/o=Company...

Adam,

Thanks, I have tried that and I will need about 20-30 separate scripts to do it.  Time wise, I would have been done doing it that way, but now it...

Correction:  Still in search of answer.......

If anyone could be so kind

Doug

I fixed it.

select

"_EMAILID_",

(substring([_EMAILID_],0,charindex ( 'EX',[_EMAILID_])))

+'EX:/o=Company/ou=Data Center'+

+(substring([_EMAILID_],charindex ( '/cn',[_EMAILID_])+10 ,len([_EMAILID_])))

FROM _CUSTOMER_

WHERE CLIENT ='DJONES'

SAWEET!!!

Thanks, I knew there was a better mouse trap.

Doug

Gila,

Thanks for posting, unfortunately when I tried this the results were null.

So I verified that I had selected correct data and compared results, yep it was correct.  Which means this...

Mr. Bill,

Ooooops.... Ya got me.....

Should have used that or <7

Thanks

Doug

Grasshopper you beat me to it...

However do want to include that the year should be defined as well.

Add datediff(yy,dateorder,getdate())=0

Had a report that gave too many results and remembered that I...

From the NAMSYSHTMLFORMS

0 78 Problem Management <INPUT id=50 style="VISIBILITY: hidden" maxLength=1 name=50 datatype="char" DEType="69">   <INPUT id=16 style="VISIBILITY: hidden" maxLength=1 name=16 datatype="datetime" DEType="21319">   <INPUT id=11 style="VISIBILITY: hidden" maxLength=5 name=11 datatype="varchar" DEType="85" FKColumn="6">   <INPUT id=4...

David,

Thanks for responding so quickly.

Example:FPKColumn="1" datatype="int"> <INPUT id=8 style="VISIBILITY: hidden" name=8 DEType="78"

The FPKColumn references that is a Foriegn Key that is the primary for that table, Input ID=8 is the...

Andy

I used the charindex.

Douglas

Gregory and Andy

Thanks.

I was right there but could not see the trees for the forest.

Tried to do an input like I do in Oracle and correct me if I...