check for empty space

[Bell1991]

How do i check if a column has empty spaces in it?

I have a column that can have 1,2,3,4... empty spaces.

Thanks in advance

 

[mrdenny]

Are the empty spaces at the begining of the field, the end of the field? Can you provide some sample data?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com