Posted by: STUPIDA April 29, 2010
SQL server help please
Login in to Rate this Post:     0       ?        

There might be a empty string or even a special character that is not visible under ur current setings. Or whatever..........


Do Update


set column = null


where LEN(Ltrim(Rtrim(Column))) = 0

Read Full Discussion Thread for this article