Removing data from tables

[prg1]

I have so far failed to come up with an adequate way of deleting certain rows of data from a table.

I have two entities, Emp_No and Emp_Name. Along with this i Have one more, D_of_B.

How can i delete an Employee's Employee number and name if their Date of Birth is after 31-12-1980? Every time i've tried the program ends up deleting either the wrong data or all of it! It's driving me mad!!

 

[carp]

Assuming your database recognizes '31-12-1980' as a date, then
DELETE FROM my_table WHERE d_of_b > '31-12-1980' should do the trick.

 

[tlbroadbent]

Which Databse are you running? Is the D_of_B column defined as datetime or character data? If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm