I made one as follows,

CREATE FUNCTION match (@p1 varchar(100), @p2 varchar(100))

RETURNS int as

BEGIN

 declare @mark-3 int

 declare @tstr varchar(100)

 declare @f varchar(100)

 declare @i int

 select @mark-3 = 100

 select @tstr...

But there are not mentioned anything to generate Matching score,

in mysql, there has Match() function, in MSSQL it seems only able to get the search ranking by Full text search...

For example, user input address, then list out the simular address with sorting by matching score.

Finally, I found the problem that it must set the locale to Taiwan or English before install the SQL.

But another problem is coming, the SQL prompt cannot run specific program on...

Before I overwrite the SQLSUI.DLL from SP, I got the error _INS5576._MP,Ver  5.53.168.0,Fail in Module  sqlsui.dll Verson 2000.80.194.0,Error Address  0x000280fd?

Now, I got error about

11:45:09 End Action DlgCollation

11:45:09 End Action ShowDialogs

11:45:09 Action CleanUpInstall:

11:45:09 StatsGenerate returned: 2

11:45:09 StatsGenerate (0x0,0x1,0xf00000,0x100,1028,303,0x0,0x10000008,0,0,0

11:45:09 StatsGenerate -1,Administrator)

11:45:09 Installation Failed.