I have a varchar field that I would like to group on.

Except I'd like to clump all the rows containing a `'.'` character into one group

**Starting Table**, with the following 5 entries in the "Name" field:

```
Aaa Aa
Bbb Bb
Ccc.Cc
Ddd.Dd
Eee.Ee

```

**Expected grouping**:

```
Aaa Aa
Bbb Bb
HasDot

```

Maybe using something along these lines?

```
Select "Name", count(*)
from MyTable
group by "Name"
-- group normally except for the group containing '.'

```