Try to remove everything to the right of SF

[murphy]

I have a query where I want to remove everything to the right of SF in a column. I am using access 2007



SELECT Left(STORE_SIZE,InStr(1,STORE_SIZE,"SF") +1) AS R_STORE_SIZE
FROM TENANT_TBL
WHERE DISPLAY = 1

The error that is returned to me is
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.

[June7]

I just tested Left("abSFcde",Instr("abSFcde","SF")+1) and it works. No idea what could cause that error.

[pdebaets]

Check the spelling of your field names. Also, Access has a number of reserved words. "Display" MAY be one of them. To tell Access that this is a field name instead of a reserved word, enclose it in brackets like so

[Display]