I have a column in my table with values like this:
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. I will create the right
half of the column based on their input ("03122005" or "01282006").
However, if I use > or < with a %01282006, it gets everything from the
This select does not work:
select * from table_1 where substring(column_1,8) > '01282006';