what about in the case where between Nov 1 and Mar 1? ie: BETWEEN '1101' AND '0301' This doesn't work. I need a solution for this where it spans a year change but we don't want to include year as this is a recurring scheduler. maybe two betweens? BETWEEN ('1101' AND '1231) OR ('0101' AND '0301')
–
JJ_Coder4HireFeb 21 '14 at 15:07

@JJ_Coder4Hire If you need that, then you could ask a question and specify exactly what are your requirements (oh, and make sure to first search SO for similar questions)
–
LamakFeb 21 '14 at 15:17

@Lamak. good point. since my search query brought this back I have included the solution I just figured out. thanks
–
JJ_Coder4HireFeb 21 '14 at 15:40