columns check

[tran008]

I need to check to see if the columns from the table are empty or the length not long enough. Currently this is what I got...is there a better way to write these:

INSERT INTO #tmpTBL
SELECT col1 FROM tbl WHERE ISNULL((col1,'')='' or len(col1) < 5)

INSERT INTO #tmpTBL
SELECT col2 FROM tbl WHERE ISNULL((col2,'')='' or len(col2) < 5)

INSERT INTO #tmpTBL
SELECT col3 FROM tbl WHERE ISNULL((col3,'')='' or len(col3) < 5)

thanks

 

[SQLDenis]

where len(ISNULL(col1,'')) < 5

yours is redundant '' = less than 5
null (with is null) is less than 5

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions