http://www.crmsql.com Use SQL queries to get answers from GoldMine Fri, 30 Jul 2010 07:48:19 +0000 http://wordpress.org/?v=1.5.2 http://www.crmsql.com/?p=4#comment-8 Thu, 22 May 2008 20:30:48 +0000 http://www.crmsql.com/?p=4#comment-8 Thanks good tip - added the change Thanks good tip - added the change

]]> http://www.crmsql.com/?p=4#comment-2 Mon, 29 May 2006 08:54:30 +0000 http://www.crmsql.com/?p=4#comment-2 This was absolutely great help, but.. The field cs.contsupref only contains the first 35 characters of the email address. The other characters are (unbelievably!) stored in cs.address1. Use the following query to always get the complete address: SELECT c1.contact ,concat(cs.contsupref, cs.address1) AS EmailAddress ,c1.accountno FROM contact1 c1 JOIN contsupp cs ON c1.accountno=cs.accountno WHERE cs.rectype = 'P' AND cs.contact = 'E-mail Address' AND cs.zip LIKE '_1__' This was absolutely great help, but..
The field cs.contsupref only contains the first 35 characters of the email address. The other
characters are (unbelievably!) stored in cs.address1. Use the following query to always get
the complete address:
SELECT
c1.contact
,concat(cs.contsupref, cs.address1) AS EmailAddress
,c1.accountno
FROM
contact1 c1
JOIN contsupp cs
ON c1.accountno=cs.accountno
WHERE
cs.rectype = ‘P’
AND cs.contact = ‘E-mail Address’
AND cs.zip LIKE ‘_1__’

]]>