sqlsql-serverasp.net-mvc

SQL Selecting if "active" = true

In my ASP.NET MVC application i've been trying to select the data from the table from users that are ACTIVE, which is on a column from the database as true or false, however when i try to do this code, it doesn't show any data:

Solution

  • if you are on sql server and datatype of Activo column is bit, then the correct syntax is :

    SELECT [NumMec], [NomeCompleto] FROM [CORE_USERS] WHERE [Activo] = 1

    bit = 1 means true