Search results for query: *

Unclejimjob - thanks very much but I've sorted it using the solution in the older thread.....

BMarks - doesnt seem like theres an obvious solution in IB6. I needed to create a boolean column as part of the query and make it true if a select brings back 'x' data and false otherwise. I did this indirectly by using a union instead of an if statement. I.e. bring back all the true results...

Actually - that was a daft cut n' paste example from the web. The oracle query to be translated into IB6 is: select c.carname, c.carid, decode( carid, (select carid from customercar where carid = c.carid and custid = 1), 'Y', 'N' ) as preference from car c So -...

Thanks unclejimbob...but I was referring to an 'if then else' within a select statement - i.e. a case equivalent but using IB6. It has to be within a select statement, not a stored procedure. This is certainly embarassing stuff to be discussing publicly but the truth is...I can't find a way to...

Hi - stupid/spimple question but whats the equivalent of an oracle decode function in interbase? Is there a case statement? Or perhaps, if then else? I can find absolutely sod all resouces on interbase syntax on the net or the IB help. Can you also point me to any useful synatax links that I...