Query check empty field

Help
1

Hello guys,

I have an Access DB where I have stored data.
I’m trying to do a select from UiPath that looks like this

“SELECT * FROM Tabella1 WHERE RobotStatus='”+“”+“'”

The problem is that in my WHERE clause i’m trying to retrieve all rows that has RobotStatus column empty. I actually can’t reach this, any advice? What should I write to check if RobotStatus is empty?
Thank you in advance

2

Hi @a.calabro,

Please try the below query.

"Select * from Tabella1 WHERE RobotStatus is null or RobotStatus = '' "

Warm Regards,
Ranjith Udayakumar

3 Likes
3

Thank you Ranjith, it works! :smile:

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.