I have a field with "Data"
similar to
"@@"@@T_001_Version = "v2009.01.13.1_1.7"@@T_002_ = "@@T_749_formstatus = "0"@@T_750_finalscorestatus = "Draft"@@M_752_ = "*Hx of AH, VH, and d....
You gave us some business rules but you also stated that each of these business rules has an exception. Also is the above supposed to represent one of the values?
declare @data varchar(1000)
set @data = ' "@@"@@T_001_Version = "v2009.01.13.1_1.7"@@T_002_ = "@@T_749_formstatus = "0"@@T_750_finalscorestatus = "Draft"@@M_752_ = "*Hx of AH, VH, and d....'
Some of these values in the field are large I want to pull only whats in between @@T_750_finalscorestatus = and @@M_752
Some of them are large and you want only a portion? What defines large?
sorry forgot to mention sometime the field ends on @@T_750_finalscorestatus = "Draft" not being between two values and for that matter not always followed by @@M_752_
HUH???
so I guess I'm looking for what follows @@T_750_finalscorestatus = " until the closing "
HUH???
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/