Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Trimp

Status
Not open for further replies.
Beginner613

Beginner613

Technical User
Joined
Dec 7, 2006
Messages
8
Location
US
Hi All,

I want to creat a query (Delete query) which is going to erase empty cells in my table. How should I reffer to empty cells? "" doesnt work. I heard something with Function called Trimp? Can somebody please provide an example or something.

Thanks a lot,
B
 
Sort by date Sort by votes
Try:
Code: 
DELETE YourTableName.* 
FROM YourTableName 
WHERE (yourfieldname is Null or yourfieldname = "")

EasyIT

"Do you think that’s air you're breathing?
 
Upvote 0 Downvote
now you realize that this will delete the entire record? Always make a backup before deleting in case you've made an error.

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top