With much blood, sweat and tears and finally finding a source of help.
I know of this:
SELECT
pur.epa_registration_num,
prod.mfg_firmno,
prod.label_seq_no,
prod.revision_no,
prod.reg_firmno
FROM
pur89raw pur,
product prod
WHERE
(pur.chemical_code LIKE '%185' OR pur.chemical_code LIKE '%573') AND
cast(substr(pur.epa_registration_num,0,7) AS number(7)) =
prod.mfg_firmno AND
cast(substr(pur.epa_registration_num,8,5) AS number(5)) =
prod.label_seq_no AND
cast(substr(pur.epa_registration_num,13,2) AS char(2)) =
prod.revision_no AND
cast(decode(rtrim(substr(pur.epa_registration_num,15,7)),0,
substr(pur.epa_registration_num,0,7),
substr(pur.epa_registration_num,15,7)) AS number(7)) = prod.reg_firmno
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3050
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
