Date queries in SQL*Forms

We've got a form which has a date field in the format MON-YY (since the users don't care about the day of the month).

But, any queries on this field produce fewer rows than we'd like, since the default conversion assumes the 1st day of the month (ie. a query on SEP-93 is actually a query on 01-SEP-1993 00:00:00).

Having experimented, we found that replacing the first character of the month with a % almost works, in that it converts the database value to a character string and then uses LIKE to compare them.

This is horrible though, and automating it with a pre-query trigger is unreliable.

Does anyone know how to tidy this up?

It's Forms 3 under Oracle 6 btw.

--
  _________________________   __________________________________________
 /  Tommy Wareing          \ /  In the beginning, there was The Bomb    \
|  p0070621_at_brookes.ac.uk   X   And The Bomb said "Let there be Light!"  |
 \  0865-483389            / \     - The Bomb, Dark Star                /
  ~~~~~~~~~~~~~~~~~~~~~~~~~   ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~