| Subject | Re: Problem with query parameter |
|---|---|
| Author | emb_blaster |
| Post date | 2009-03-10T16:42:17Z |
another way:
select * from TABLE
where (FIELD = cast(:param as TypeFIELD)) or
(cast(:param as TypeFIELD) is null)
but well, it is more complex and still don´t use any index... :(
select * from TABLE
where (FIELD = cast(:param as TypeFIELD)) or
(cast(:param as TypeFIELD) is null)
but well, it is more complex and still don´t use any index... :(