I wanted to take all of the Addresses that are same and count them regardless of the Name. So I tried:

SELECT COUNT(PracticeAddressFirstLine) as nCount,

Name as nName,

PracticeAddressFirstLine as PAF

FROM GlobalOrganization

WHERE...

I figured it out! It was missing the "," here:

SELECT COUNT(Name) as nCount,

Name as nName,[/size]

PracticeAddressFirstLine as PAF

FROM GlobalOrganization

WHERE PracticeAddressState = 'TX'

GROUP BY Name,PracticeAddressFirstLine

ORDER BY nCount

Thanks so much...

Thanks for the answer, now it's coming back with:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'PracticeAddressFirstLine'.