See Alex's response about issues with different formats. With some dumb
luck and
some scrubbing of the data, it might work. Once the scrub is completed,
a trigger
to insure a proper date value might save a change to the table.

Steve Summers wrote:

>""Andrew Neillans"" <andy@...> wrote in message
>news:babb03+sc7l@......
>
>
>>Hi,
>>...
>>Is it possible to do a date search on a varchar, or am I going to
>>have to try and find the original source of the application that runs
>>this database and change it? (Please dont say this .... :p).
>>
>>
>
>Don't panic- See the Interbase 6.0 language reference (IB6LangRef.pdf,
>downloadable from IBPhoenix.com). Under the topic fro Cast() it says:
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus