FIX: PATINDEX on CONVERT May Cause GP Fault
  
PSS ID Number: Q110566
Article last modified on 01-24-1995
 
4.20
 
WINDOWS
 

----------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft SQL Server, version 4.2
----------------------------------------------------------------------
 
BUG#  NT: 581 (4.2)
 
SYMPTOMS
========
 
Using the TEXT function PATINDEX with a static string converted to TEXT
using the CONVERT function may cause a general protection fault (GP fault)
on SQL Server.
 
WORKAROUND
==========
 
Use an equivalent C or Visual Basic string function if performing
DB-Library (DB-Lib) programming.
 
STATUS
======
 
Microsoft has confirmed this to be a problem in SQL Server version 4.2 for
Windows NT. This problem was corrected in SQL Server version 4.21. For more
information, contact your primary support provider.
 
MORE INFORMATION
================
 
The query,
 
   SELECT PATINDEX("x", CONVERT(TEXT, "x"))
 
may terminate the SQL Server for Windows NT client with the error:
 
   Access Violation
 
Additional reference words: 4.20 kernel GP-Fault
KBCategory: kbprg
KBSubCategory: SSrvWinNT
 
=============================================================================
 
Copyright Microsoft Corporation 1995.
