Viewing 3 posts - 1 through 3 (of 3 total)
This is what I ended up using:
--split on space near 25th place
UPDATE #SplitAddress
SET Address1 = left(AddressToSplit,25 - charindex(' ',reverse(left(AddressToSplit,25)))),
Address2 = right(AddressToSplit,len(AddressToSplit)-(25- charindex(' ',reverse(left(AddressToSplit,25)))+1))
WHERE charindex(' ',AddressToSplit) > 0
AND Len(AddressToSplit) >...
March 23, 2007 at 8:20 am
Thanks for the replies!
Joel's worked great!
There are few address1's longer than 25 with David's. Some are listed below:
1600 PLATT SPRINGS ROAD APT...
March 21, 2007 at 11:38 am
THANKS SO MUCH!!! I have been waiting a long time to set this up. I am just in application support and my Groupwise/Novell people couldn't or wouldn't...
January 27, 2005 at 6:42 am
Viewing 3 posts - 1 through 3 (of 3 total)