ORA-00900: invalid SQL statement when using Between

I'm trying to bring a range of dates (eg: form 200405 to 200507) applying a between statement as follows:

select BL_MO BETWEEN 200405 AND 200507 From PREMIUM_FACT

But when ever the sql statement is executed the following error is displayed

ORA-00900: invalid SQL statement

Any idea?

is the between function applied correct?

Thank you very much!

[403 byte] By [ddeleona] at [2007-11-26 15:18:30]

# 1

I apologize the SQL statement is as follows:select BL_MO From PREMIUM_FACTWhere BL_MO BETWEEN 200205 AND 200201

ddeleona at 2007-7-8 11:01:23 >

# 2

I would suppose that you are guessing as to the exact sql.Post the code not what you think it is. Alternatively print it and post that.

jschella at 2007-7-8 11:01:23 >

Database Connectivity New Topic