Subject Re: [firebird-support] Select and where
Author Lele Gaifax
>>>>> "Michael" == Michael Vilhelmsen <Michael.Vilhelmsen@...> writes:

Michael> Hi Can I in the where part of a select statement call a
Michael> procedure ?

Michael> Something like

Michael> Select * from MyTable Where MyProcedure (SomeField) =
Michael> Something

I use this pattern, that seems equivalent

SELECT t.field1, sp.field2
FROM MyTable t LEFT JOIN MyProcedure(t.SomeField) sp
WHERE sp.SomeField = :SomeValue

I'd recommend using table aliases everywhere, and definitively no
"SELECT *" :)

ciao, lele.
nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri
real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.