is it possible to select EXISTS directly as a bit?

by

No, you’ll have to use a workaround.

If you must return a conditional bit 0/1 another way is to:

SELECT CAST(
   CASE WHEN EXISTS(SELECT * FROM theTable where theColumn like 'theValue%') THEN 1 
   ELSE 0 
   END 
AS BIT)

Or without the cast:

SELECT
   CASE
       WHEN EXISTS( SELECT 1 FROM theTable WHERE theColumn LIKE 'theValue%' )
            THEN 1 
       ELSE 0 
   END

More Related Contents:

  1. Convert text to system date format [duplicate]
  2. How to get a particular preceding value of a column in SQL [closed]
  3. SQL where clause odd behavior [closed]
  4. How do I escape a single quote in SQL Server?
  5. Simple way to transpose columns and rows in SQL?
  6. What is the meaning of the prefix N in T-SQL statements and when should I use it?
  7. Only inserting a row if it’s not already there
  8. Unpivot with column name
  9. Selecting data from two different servers in SQL Server
  10. Maximum size for a SQL Server Query? IN clause? Is there a Better Approach [duplicate]
  11. SQL JOIN vs IN performance?
  12. Most efficient way in SQL Server to get date from date+time?
  13. Convert varchar into datetime in SQL Server
  14. TSQL Pivot without aggregate function
  15. How to generate a range of dates in SQL Server
  16. SQL RANK() versus ROW_NUMBER()
  17. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  18. How do I delete from multiple tables using INNER JOIN in SQL server
  19. Check if a row exists, otherwise insert
  20. SQL : BETWEEN vs =
  21. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  22. How do I perform a GROUP BY on an aliased column in SQL Server?
  23. How do I make a composite key with SQL Server Management Studio?
  24. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  25. TransactSQL to run another TransactSQL script
  26. Getting Dates between a range of dates
  27. The most elegant way to generate permutations in SQL server
  28. SQL – How do I get only the numbers after the decimal?
  29. How to retrieve records for last 30 minutes in MS SQL?
  30. Why do SQL Server Scalar-valued functions get slower?

Leave a Comment