Posted by David Portas on 04/04/06 11:54

ShihChengYu@gmail.com wrote:
> Dear All:
>
> I encounter one problem when I want to implement my thought. My thought
> is that user want to search a record of someone but maybe user would
> type wrong name or spell name wrong. I wish to compare the string which
> user inputed to the database column using "Socre Method". "Score
> Method" has a variable "grade" to accumulate the score. I want to
> convert the string to char array, and compare the char one by one. If
> the string is more accurate , the grade is more high. At last, I choose
> the most higher score record to show. How to do this thought with tsql?
> Could give me some tips or guide to learn? I will appreciate your
> kindness, thanks.

http://www.merriampark.com/ld.htm

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

[Back to original message]