deleting records that have a column empty

[Tailgun]

I'm somewhat new to Microsoft SQL2K and know just about enough to get myself in trouble so I need some help.

If I run a query like Select* from tblClaim where FileNo is "" I want to then delete those records from the db.

Meaning any record with the FileNo column being empty I want to delete that complete record from the SQL db.

I also want to run it as a script allowing the user to delete those records by just selecting a menu item in VB to delete those records. Any and all help would be greatly appreciated.

Thanks

 

[vongrunt]

Simply replace SELECT * with DELETE.

Overall, this is a good practice - first write SELECT statement to check which records will be deleted, then replace SELECT [columns] with DELETE.

Also: some column values can be NULL - take care of that.