Good explanation Jeff. A small point, your solution fails if there is more than 1 space between the 2 words. e.g 'Lincoln Lincoln' has length 16. So the left half is 'Lincoln ' and the right half is ' Lincoln'.

This is fixed by adding RTRIM and LTRIM to left and right half respectively:

WHEN RTRIM(LEFT(Address,LEN(Address)/2)) = LTRIM(RIGHT(RTRIM(Address),LEN(Address)/2))

Of course, there are probably other scenarios that don't work, but the OP needs to test with his data. 🙂