I am supporting to one e governence project in telugu language and names are in english. My requirement is if names are matchning status is 'Y' else 'N' , i have used Difference () function but the result is not accurate as expected. How can we acheive it? B DEEPTHI y B.Deepthi GURRAM HIMA BINDU y Gurram Himabindu S SINDHU y S. Sindhu Y PRUDVI KRISHNA y Y. Prudvi Krishna YERRAYAMMA NANGIREDDY n Nahgireddy Simhadri yerrayamma pittala y Pittala Errayamma Yerrayamma seedari n Seedhari Lovaraju Yerrayyamma bandaru n bandaru Dongodu

Please check this link for similar problem - https://www.red-gate.com/simple-talk/blogs/string-comparisons-in-sql-the-longest-common-substring/ https://www.red-gate.com/simple-talk/blogs/string-comparisons-in-sql-the-longest-common-substring/

Hi Kapil, I tried, but, output is not as expected.

Your can try below , 1. Remove all other characters except alphabets from the name. 2.Convert string to UPPER/LOWER and compaire the string. 3.Match the number of char count from source and target name. I hope so.

Answers

Column Values Pronouncing same then y or n

Sai Reddy

612

I am supporting to one e governence project in telugu language and names are in english. My requirement is if names are matchning status is 'Y' else 'N' , i have used Difference () function but the result is not accurate as expected. How can we acheive it?

B DEEPTHI	y	B.Deepthi
GURRAM HIMA BINDU	y	Gurram Himabindu
S SINDHU	y	S. Sindhu
Y PRUDVI KRISHNA	y	Y. Prudvi Krishna
YERRAYAMMA NANGIREDDY	n	Nahgireddy Simhadri
yerrayamma pittala	y	Pittala Errayamma
Yerrayamma seedari	n	Seedhari Lovaraju
Yerrayyamma bandaru	n	bandaru Dongodu

Answers (3)

Next Recommended Forum

Store Procedure with one parameter

Second & third sub-forms not working