Michael Parker wrote:
debug: bayes: tok_get_all: Token Count: 302
debug: bayes: tok_get_all: SQL Error: [Microsoft][ODBC SQL Server Driver][SQL Se
rver]'RPAD' is not a recognized function name. (SQL-42000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepare
d. (SQL-42000)(DBD: st_execute/SQLExecute err=-1)
debug: cannot use bayes on this message; none of the tokens were found in the da
tabase
This is the problem, SQL Server doesn't know what the RPAD function
is. How does SQL Server handle Char types? does it return spaces at
the end of the string?
MS SQL Server might need at a custom module to handle things
correctly.
Michael
From past nightmares I recall using something like:
select left(token + ' ', 5)
Daryl
