InStr() Not Supported???

[MikeC]

I have an Access (XP) Project (ADP) front end that I'm using with an MSDE
2000 back end. The ADP file uses a trusted connection to connect to the
back end.

I'm trying to use the InStr() function in a stored procedure, but I keep
getting the below error message:

"ADO error: 'InStr' is not a recognized function name"

Books Online specifically says that SQL Server supports the "InStr" VBA
function. At least until now, I had believed that MSDE 2000 supported the
same *functions* as SQL Server. Is this not so?...or am I making an error
in my below stored procedure?

ALTER PROCEDURE dbo.sp_CompUserName
AS
SELECT
UserAccountName,
Left((e-mail address removed)

 

[Norman Yuan]

SQL Server supports VBA's InStr()? No way.

SP in SQL Server/MSDE is written in T-SQL, which does not have "InStr()"
function, however CharIndex() function does basically the same thing.