How to set true or false by checking null in TSQL?

Question

What is the correct syntax for returning TRUE if the field is not NULL and returns FALSE if it is NULL in TSQL?

SELECT -- here return TRUE if table.Code IS NOT NULL. And FALSE otherwise FROM table 

Answer 1

  select case when code IS NULL then 'false' else 'true' end as result from the_table 

Answer 2

There is no true or false in mssql. You can use the data type bit and consider 1 as true and 0 as false:

 SELECT CASE WHEN Code IS NULL THEN CAST(0 AS BIT) ELSE CAST(1 AS BIT) END as Result FROM table 

Answer 3

For pleasure:

 SELECT ISNULL(NULLIF(ISNULL(code,0),code),1) FROM table 

Answer 4

ints are passed to true, therefore:

CAST (ISNULL (int, 0) AS bit)

You can use Length (x) if its string type