InStr() Not Supported???

  • Thread starter Thread starter MikeC
  • Start date Start date
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((e-mail address removed)
 
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.
 
Great. I'll use CharIndex(). Thanks Norman.

Norman Yuan said:
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.

MikeC said:
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)
Click to expand...
Click to expand...
 
Back
Top