您仅限于 小型函数列表，用于文本数据类型.

You are limited to small list of functions for text data type.

我只能建议从 PATINDEX 开始，但从 DATALENGTH-1、DATALENGTH-2、DATALENGTH-3 等开始向后工作，直到得到结果或结束在零(DATALENGTH-DATALENGTH)

All I can suggest is start with PATINDEX, but work backwards from DATALENGTH-1, DATALENGTH-2, DATALENGTH-3 etc until you get a result or end up at zero (DATALENGTH-DATALENGTH)

这确实是 SQL Server 2000 根本无法处理的事情.

This really is something that SQL Server 2000 simply can't handle.

编辑其他答案:REVERSE 不在 SQL Server 2000 中可用于文本数据的函数列表中

Edit for other answers : REVERSE is not on the list of functions that can be used with text data in SQL Server 2000