'SUBSTRING_INDEX' is not a recognized built-in function name.
843859Aug 8 2007 — edited Aug 8 2007actually iam modifing the servlet code to connect with MSSQL.previously it was MYSQL.now compiling is ok.
while running it shows error at the top of the linked page as...
error
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]'SUBSTRING_INDEX' is not a recognized built-in function name.
->can any one give me the solution for this error.