Trimp

[Beginner613]

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

 

[easyit]

Try:

DELETE YourTableName.* 
FROM YourTableName 
WHERE (yourfieldname is Null or yourfieldname = "")

EasyIT

"Do you think that’s air you're breathing?

 

[lespaul]

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