>Ok, now assuming I already had City & State columns, how would I use this logic to update those 2 fields from CityState?
>
>

Ok, never mind.

update myTable set City = charindex(' ',reverse(CityState)), substring(CityState, 1, 
case when charindex(' ',reverse(CityState)) = 0 then len(CityState) 
else len(CityState) - charindex(' ',reverse(CityState)) end), state = 
SUBSTRING(CityState, case when charindex(' ',reverse(CityState)) = 0 then len(CityState) +1 else 
len(CityState) - charindex(' ',reverse(CityState))+2 end, LEN(CityState)) 

>>Interesting, I thought substring (@Var, len(@Var), len(@Var)) will give you an empty string.
>>
>>
>>I can say, I have blonde moments myself :)
>>