In a message dated 4/2/2004 10:06:39 PM Pacific Standard Time,
[EMAIL PROTECTED] writes:
Tony,
Stupid question... If you and I built a company which was strictly
Hey my name's not Tony but if there's money involved you can call me anything
you want.
Will
--
u2-users mailing list
Thanks to all who have provide some good ideas. The conversion has occurred
and is in the growing pains. Still a mistmatch but there's no going back.
Perhaps I'll take this approach to learn Crystal Reports or MS Access
reports. There are many previous reports and downloads that can't possibly
Mark,
Tell them you are re-purposing the old MV system as a data warehouse
as a cost savings measure. That they'll understand and hopefully
appreciate. Then do what you suggested:
One strange thought occurred to me that may not fly. Export all the
sales/customer/product data back to the MV
One thing I think everyone's missed (deliberately or otherwise) was that Sara's
original post had a constraint with a LEADING wildcard (WHERE address LIKE
'%EXPLORATION').
The argument that has been raging since has used examples with TRAILING wildcards
(WHERE name LIKE 'Sara%').
Apples and
Joe,
The example you specified (below) is case-SENSITIVE. It will only return rows where
the value begins with the four upper-case letters designated. In particular, it will
not produce the results you showed (and could never select the row with SARRA).
Your query is identical to the SQL: