Loading

check for spaces in column

dc

14y2k

In a sql server 2008 r2 database column that is defined as varchar, how do you check to see if the field contains all spaces regardless of the length the field is?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abdu Rafeeq14y ago
select ColumnName from Table where Column !=' '
Vulpes14y ago
Try:

SELECT someColumn FROM table WHERE RTRIM(someColumn) = ""

or, if you don't want to include columns containing empty strings:

SELECT someColumn FROM table WHERE someColumn != "" AND RTRIM(someColumn) = ""