InStr() Not Supported???

M

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(, InStr(1, dbo.tblEmployee.Email, "@"))
FROM
dbo.tblEmployee

I already know how to do the above in VBA and Jet. I'm just trying to
understand the source of this specific problem.
 
N

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.
 
Top