>>UPDATE ContactInfo1 >> SET City = CASE WHEN lbcms.dbo.occurs(' ', CityState) = 0 THEN lbcms.dbo.getwordnum(CityState, 1, ' ') >> WHEN lbcms.dbo.occurs(' ', CityState) = 1 THEN lbcms.dbo.getwordnum(CityState, 1, ' ') >> WHEN lbcms.dbo.occurs(' ', CityState) = 2 THEN SUBSTRING(CityState, 1, lbcms.dbo.at(' ', CityState, 2)) >> END, >> State = CASE WHEN lbcms.dbo.occurs(' ', CityState) = 0 THEN NULL >> WHEN lbcms.dbo.occurs(' ', CityState) = 1 THEN lbcms.dbo.getwordnum(CityState, 2, ' ') >> WHEN lbcms.dbo.occurs(' ', CityState) = 2 THEN lbcms.dbo.getwordnum(CityState, 3, ' ') >> END >> WHERE CityState IS NOT NULL >> >>>>
>>CityState City State >>----------------- ------------- ------ >>BREA CA BREA CA >>SAN DIEGO CA SAN DIEGO CA >>NORTHBROOK IL NORTHBROOK IL >>SAN DIEGO SAN DIEGO >>ENCINITAS ENCINITAS NULL >>VISTA VISTA NULL >>ENCINITAS ENCINITAS NULL >>POWAY POWAY NULL >>CARLSBAD CA CARLSBAD CA >>LINCOLN NE LINCOLN NE >>SAN MARCOS CA SAN MARCOS CA >>OCEANSIDE OCEANSIDE NULL >>ENCINITAS ENCINITAS NULL >>OCEANSIDE OCEANSIDE NULL >>>>