SQL Parsing

Message Topic Search Topic Options Post Reply Create New Topic Printable Version


   
DECLARE @CityState VARCHAR(255)

SET @CityState='Herndon,VA'

SELECT 

SUBSTRING(@CityState, 1, CHARINDEX(',',@CityState)-1) City, 

SUBSTRING(@CityState, CHARINDEX(',',@CityState)+1, LEN(@CityState)-(CHARINDEX(',',@CityState)-1)) StateCode

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version
	Quote Reply Topic: SQL Parsing Posted: 26 Feb 2009 at 11:50am
	DECLARE @CityState VARCHAR(255) SET @CityState='Herndon,VA' SELECT SUBSTRING(@CityState, 1, CHARINDEX(',',@CityState)-1) City, SUBSTRING(@CityState, CHARINDEX(',',@CityState)+1, LEN(@CityState)-(CHARINDEX(',',@CityState)-1)) StateCode