Within my VB code, I have an sql statement which suddenly stopped working for no apparent reason. When I copied the code into Toad and removed the VB-specific text, it ran successfully.
The level of complexity of the code is this: a union of two "select"s, each "select" has Utrim and Ucase specified for two of the variables. and it contains an "order by" clause.
That doesn't seem very complex to me.
When I removed the Utrim/Ucase specifications, the union and the "order by", it worked, but it's only partially what I need.
Any ideas how to get around this?