RE: SQL Query Scalar Function Versus Second Table

qsrvbas@xxxxxxxxxxxx (Tom Liotta) wrote:

> Are the dashes always in the same place? Is data entry on a
> green-screen? If both are 'yes', then consider simply masking
> data entry of part number so the user never enters a dash --
> that is, use the EDTMSH() keyword.

Even if the dashes are in the same place for every part number now it could
be dangerous to assume they always will be, even if the users give you a
sworn affidavit to that effect. We techies need to be very careful about
imposing artificial restrictions on our companies' business rules because
we prefer a solution that's obviously right from our point of view.

--
Dave...
               _________  ,___o
             __________   _\ <;_        http://www.audax.uk.net
           ___________   (_)/ (_)       http://www.twickenhamcc.co.uk
=======================================================
The opinions expressed in this communication are my own and do not
necessarily reflect those of my employer.


______________________________________________________________________
This message may contain confidential information which may also be legally 
privileged and is intended only for the use of the parties to whom it is 
addressed. If you are not an intended recipient you are hereby notified that 
any disclosure, copying, distribution or use of any information in this e-mail 
is strictly prohibited. If you receive this message in error please notify the 
sender by return e-mail and then destroy it. Further, we make every endeavour 
to keep our network free from viruses. However, you do need to verify that this 
e-mail and any attachments are free of viruses as we can take no responsibility 
for any computer viruses which might be transferred by way of this e-mail. All 
information and attachments remain the property of Stolt Offshore Group and 
should be held as confidential.