Question about writing code

[Former Member]

Hi Everyone,

I need some help in writing some code.

delete DATA_PACKAGE where version ne '010' and

( version LT '040' or version GT '050' ).

delete DATA_PACKAGE where fiscyear < '2007'.

Is there a way where I can restrcit version 040-050 to only 2008 and get version 010 from 2007.

Thanks

[Former Member]

Something like this should work

delete DATA_PACKAGE 
  where ( fiscyear = 2007 AND version ne '010' )
     or ( fiscyear = 2008 and ( version LT '040' 
                            and version GT '050' ).

whoops.. corrected

Edited by: Paul Chapman on Jun 9, 2008 1:23 PM

[Former Member]

Hello,

  DELETE data_package WHERE ( version = '010' AND fiscyear = '2007' ) OR
    ( version BETWEEN '040' AND '050' AND fiscyear = '2008' ).

Regards.

[Former Member]

answered