Re: Newbie Help Plz

you're looking for the DELETE command with WHERE clause that selects records based on the expiration date column compared to SYSDATE (the current system date on the database server)

(you really need to study the basics of sql before posting questions like this, though)

"Mumblez" <mumblez2002_at_btinternet.com> wrote in message news:bo4c9k$hji$1_at_sparta.btinternet.com...
> could someone please tell me how to remove a record that is past the
present
> date?
>
> for example if you have users that have an expiry date what sql command do
> you use to check the date and then remove that record
>
> thanks in advance
>
>
Received on Sun Nov 02 2003 - 20:12:02 CST