This is basically a sql vairant to calculate % of closeness of strings, Not same as Fuzzy Match in python, This incorporates levenshtein Logic a. Main Logic CREATE FUNCTION [dbo].[Levenshtein](@s1 N
Read more →a. This function is used to split a given string and return the positional value Example: 'ABC;DEF;GHI' is delimtied by ; and we need the positional values. CREATE FUNCTION [dbo].[func_string_splitt
Read more →a. Remove duplicates from a delimited string. Example: after string_agg you get strings as 'ABC,DEF,GHI,ABC,PQR,GHI' Here abc and ghi are duplicates Below function can be used to remove the duplica
Read more →a. Function convert inches to fraction denomination (11.01 -> 0 ft. 11-1/100 in.) step 1: function that converts decimals to fraction form (.01 -> 1/100, 0.25 -> 1/4) CREATE FUNCTION [dbo]
Read more →