Query Data Type Conversion issue with Criteria

[The Frog]

Re: Query Data Type Conversion issue with Criteria

Thankyou for that Sky,

Didnt think of this. Much appreciated. Works like a charm :-)

Cheers

The Frog

[The Frog]

Re: Query Data Type Conversion issue with Criteria

Thanks Guys for the guidance once again.

I understand the potential benefit of using a UDF, and for debugging
purposes its certainly something I have found useful. I am one who
tends to want to lean more towards the 'pure' SQL route simply for
portability's sake. Although there are differences between
implementations of SQL on different platforms, I have found it easier
to tweak the SQL than to re-write a stack of UDF's if DB platform has
to change. It also opens the sharing possibilities up considerably for
distributing the workload (at least in my little corner of the world).

I thankyou all for the time and help that you have provided, as well
as the lively discussion. I cant tell you how much I do appreciate the
efforts of all who contribute. If you are ever in Germany and need a
beer then drop me a line :-)

Cheers and Thanks

The Frog