Hi All,

I have a column in my table with values like this:

CBMON3.03122005
WESAT1.04262006
TRSAT3.01282006
..
..
..

I want to create a select statement that will allow me to retreive
records within a range of dates.

Basically the user will enter a date range from the form. I will take
that date, and try to do a range select against the right half of the
column:

select * from t1 where substring(c1,8) > '2006-01-05' AND
substring(c1,8) < '2006-01-31';

However, that returns the entire database.........

Any suggestions?

Thanks.