Parsing string

SQLServerCentral » Latest topics

Parsing string

Hi I have a filed in one of the tables and Following is the sample data in this column.
Field ID FieldDesc
1           Department ='test' AND Branch = 'Yankee' AND city = 'Brooklyn' AND State = 'NY' and country = 'USA' and

more info...