Nice Sergey. There is always a possibility that typos could be in there like for a lastname field:

2illiams ,
Smith.Holmes (instead of Smith-Holmes)
Sm1th Jones (this would work fine in the first resolution)

Not sure how to check for typos, guess those will have to be dealt with manually. The goal is to pull all records with more than one word in the field and then figure out how to break it up to where it needs to go into separate fields.

>More generic way
>

>DECLARE @Delimiters varchar(10)
>SET @Delimiters = ' ,'
>IF PATINDEX('%[' + @Delimiters + ']%', LTRIM(RTRIM(mycolumn))) > 0
>

>>Thanks Sergey, I'll try it!
>>
>>
>>>>I would like to determine the number of words in a field in a sql server table. Is there an easy way to do it? I really just need to know if there is more than one word in a field.
>>>
>>>Tracy,
>>>
>>>Assuming that words are separated by spaces and there are no leading spaces
>>>

>>>LEN(mycolumn) <> LEN(REPLACE(mycolumn, SPACE(1), SPACE(0)))
>>>