Re: Help for SQL/400

["Sunil R" <sunil_ramakumar@xxxxxxxxx>]

Will this help

DELETE FROM lib/fileWHERE field between '008048' and
'008051'


----- Original Message -----
From: "parag k panchal" <paragrishbh@rediffmail.com>
To: <rpg400-l@midrange.com>
Sent: Thursday, July 11, 2002 9:11 AM
Subject: Help for SQL/400


> Hello
> i have one problem can u help me.i am AS/400 programmer,
> i have one database file in which there is one filed
> for.eg. Field Name is CHQNO,now in this field there are some data
> below is
> some data eg.
>
> '008046'
> '008047'
> '008048'
> '008049'
> '008050'
> '008051'
> '008052'
> '008053'
>
> this filed is Alphanumeric,so through SQL/400 i want to delete
> records
>  from '008048' to '008051',so can u guide me how do i delete this
> records
>  from my database file through useing SQL/400.
>
> PLEASE GUIDE ME
>
> WAITING FOR YOUR REPLY.
>
> Thanks
>
> Regards
>
> Rishabh
>
> _________________________________________________________
> There is always a better job for you at Monsterindia.com.
> Go now http://monsterindia.rediff.com/jobs
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>