Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

DB query with a checkbox

I'm trying to run a query against the database where one of the fields displays as a check/tick box.

How on earth does one filter against that?

A basic search of:

SELECT NodeID, Client, Node_In_BAU FROM [dbo].[NodesCustomProperties]
Where ClientPrefix like '%xxx%'

returns:

But for the life of me I can't figure out how to do an "and Node_In_BAU equals Tick or No-Tick"

Find more posts tagged with

Accepted answers

The checkboxes are booleans. So field=1 should work or somthing like that.

All comments

For the record, I can do an 'Order By' but that isn't what I want

The checkboxes are booleans. So field=1 should work or somthing like that.

Thank you.

I shall go play and see what happens

Got it, but never would have without your assist @Seashore

What I need is:

>> WHERE Node_In_BAU = 0 (or 1 depending on need).

Muchas gracias or as we Welsh would say - diolch.

Varsågod, as we Swedes would say

Quick Links