Hi all,

I am having a problem with a delete statement in a stored procedure.

delete from D_LIST_HEAD
where (DETECTID=:FIND_ID) or (DATATYPE=:CHECK_DT and INT001=:FIND_ID);

It deletes the record where DETECTID=:FIND_ID

but

it does not delete records where (DATATYPE=:CHECK_DT and INT001=:FIND_ID)

how do I re-write the where clause so that it can find both ?

--
Regards,
Grant Brown

Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web : www.sitedoc.com.au

SiteDoc - Easy to Use - Powerful Results