ORA-00907: missing right parenthesis, why?

[wolves]

Here is the code

select * from my_table
where substring(name FROM 1 for 3) = 'JOE'

Here is the error:

ERROR at line 2:
ORA-00907: missing right parenthesis

Any ideas why?

 

[mrniice]

Try
select * from my_table
where substr(name,1,3)='JOE';

 

[wolves]

Thanks, that's the one.

 

[Advocate]

http://www.ss64.com/orasyntax/functions.html

regards, david - no such thing as problems - only solutions.