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

boaCASNumberVal...

Attachments Open full size