Please Share your Product Ideas with us!

All ideas are welcome. Just because the Idea doesn't make it into the product immediately does not make it a bad idea.

New boa Function: boaCASNumberValidation

The attached function should be added to any function repositories we currently maintain.

 

CREATE FUNCTION [dbo].[boaCASNumberValidation] (@CAS AS VARCHAR(16)) RETURNS BIT AS
--UDF : boaCASNumberValidation
--Author : Jeremiah Gilmore
--Version : 1.0
--Date : 20180726
--Description : Evaluates a CAS Number and Returns 1 if format and checksum are valid and 0 if Invalid.
--Example Use : dswAdmin.dbo.boaCASNumberValidation('7732-18-5') --CAS number for water
--Reference : https://en.wikipedia.org/wiki/CAS_Registry_Number

  • Jeremiah Gilmore
  • Jul 26 2018
  • Future consideration
  • Attach files
  • Admin
    Jon Green commented
    23 Aug, 2018 04:56pm

    Thanks for the information Jeremiah, I will get this added to the backlog of available functions in the DSP