Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
T-SQL find all records with a text field which is = ' '
Message
From
24/08/2006 15:34:57
John Baird
Coatesville, Pennsylvania, United States
 
 
To
24/08/2006 15:16:50
Glenn Domeracki
Michigan, United States
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: T-SQL find all records with a text field which is = ' '
Miscellaneous
Thread ID:
01148331
Message ID:
01148343
Views:
27
>I need to find all records in a table in which a text field contains only spaces. Any suggestions?
>
>Thanks
>
>Glenn



Select * from table where LEN(LTRIM(RTRIM(field))) = 0
Previous
Reply
Map
View

Click here to load this message in the networking platform