SQL Query

[sniper2000]

hi
i am trying to work "SUBSTR" Command in Access. it is not working, can anyone tell me the equivalent command in Access 97 ?

thank you

cheers,
sniper

[sniper2000]

WAT IS WRONG WITH THIS COMMAND, I AM GETTING ERROR IN THE OUTPUT COLUMN "INSTRG" ???

SELECT
FIRSTNAME,
INSTR(FIRSTNAME,'A',3,3) AS INSTRG
FROM t1;


THANX IN ADVANCE...

CHEERS,
SNIPER:cool:

[dinesh123]

Originally posted by sniper2000
hi
i am trying to work "SUBSTR" Command in Access. it is not working, can anyone tell me the equivalent command in Access 97 ?

thank you

cheers,
sniper

Use Mid command

[dinesh123]

Originally posted by sniper2000
WAT IS WRONG WITH THIS COMMAND, I AM GETTING ERROR IN THE OUTPUT COLUMN "INSTRG" ???

SELECT
FIRSTNAME,
INSTR(FIRSTNAME,'A',3,3) AS INSTRG
FROM t1;


THANX IN ADVANCE...

CHEERS,
SNIPER:cool:

U have used the wrong syntax

SELECT
FIRSTNAME,
INSTR(FIRSTNAME,'A') AS INSTRG
FROM t1;

[sniper2000]

thanx .... both codes works... ;)

[sniper2000]

WAT IS THE SYNTAX ERROR IN THE FOLLOWING COMMAND ???


SELECT
PAYEE, AMOUNT, REMARKS
FROM CHECKS
WHERE PAYEE STARTING WITH ('Ca')
AND
REMARKS LIKE 'T*';


CHEERS,
sniper
:cool:

[sniper2000]

HI SORRY MY BAD.....

THE CODE IS

SELECT
PAYEE, AMOUNT, REMARKS
FROM CHECKS
WHERE PAYEE (STARTWITH ('Ca'));

I AM GETTING SYNTAX ERROR "Undefined function "PAYEE" in the expression"

WAT IS WRONG, PAYEE IS A FIELD....

THANX IN ADVANCE...

cheers,
sniper
:cool:

[dinesh123]

SELECT
PAYEE, AMOUNT, REMARKS
FROM CHECKS
WHERE PAYEE LIKE = 'Ca*'