pick up nulls spaces and zeros

Question

i would like to pick up even zeros including null and zeros in SINGLE where clause

DECLARE @t TABLE (idt CHAR (5))
INSERT INTO @t VALUES  ( '') ,('000') , (' '), (NULL), ('123')

  SELECT * FROM @t      
  SELECT * FROM @t WHERE ISNULL(idt,'') = '' 

.

Answer 1

You can use the "OR" logical operator in the WHERE clause.

DECLARE @t TABLE (idt CHAR (5))
INSERT INTO @t VALUES  ( '') ,('000') , (' '), (NULL), ('123')

SELECT * FROM @t      
SELECT * FROM @t WHERE ISNULL(idt,'') = '' OR LEFT(idt,1)='0'

---

Kalman Toth SQL SERVER 2012 & BI TRAINING
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012

Answer 2

Try

SELECT * FROM @t WHERE ISNULL(idt,'') = '' or cast(idt as decimal(12,0))=0 

---

Many Thanks & Best Regards, Hua Min