Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag calculation Rss

   Items 1 to 1 of 1   
 

Calculating and Verifying Check Digits in T-SQL

A lot of numbers that we use everyday such as Bank Card numbers, Identification numbers, and ISBN codes, have check digits. As part of the routine data cleansing of such codes we must check that the code is valid- but do we? Dwain Camps shows how it can be done in SQL in such a way that it could even be used in a constraint, and keep bad data out of the database.  Read more...
By Additional Articles 2014/07/23 | Source: SimpleTalk | Category: calculation
Rating: (not yet rated)  Rate this |   Briefcase | 11,137 reads
   Items 1 to 1 of 1