Null or empty check for a string variable

Question

if  isnull  value            I want to know whether the above piece of code works in checking if the variable is null or empty

User · Answer

You can try this       DECLARE  value Varchar 100  NULL IF  value      OR  value IS NULL    BEGIN     select 1   END ELSE   BEGIN     select 0   END

User · Answer

Yes  that code does exactly that   You can also use   if   value is null or  value         Edit   With the added information that  value is an int value  you need instead   if   value is null    An int value can never contain the value

User · Answer

declare  sexo as char 1   select  sexo  F   select   from pessoa  where isnull Sexo 0   isnull  Sexo 0

User · Answer

Try this   ISNULL IIF  ColunmValue     ColunmValue   no units exists      no units exists   AS  ColunmValueName

User · Answer

Use This way is Better   if LEN ISNULL  Value      0                 This check the field is empty or NULL

User · Answer

Yes  it works  Check the below example  Assuming  value is not int  WITH CTE  AS       SELECT NULL AS test     UNION     SELECT    AS test     UNION     SELECT  123  AS test    SELECT      CASE WHEN isnull test        THEN  empty  ELSE test END AS IS EMPTY  FROM CTE   Result    IS EMPTY -------- empty empty 123

User · Answer

You can try   lt column name gt  is null   in the where clause

User · Answer

Yes  you could also use COALESCE  value        which is based on the ANSI SQL standard   SELECT CASE WHEN COALESCE  value             THEN  Yes  it is null or empty  ELSE  No  not null or empty       END AS IsNullOrEmpty   DEMO

[sql] Null or empty check for a string variable

Examples related to sql

Examples related to sql-server-2008

Examples related to null

Examples related to null-check