Select to comma delimited
Posted on 2007-04-10
I have a field with a string, I need to run a query and break down the results:
The field has the following value:
Opaque=1;Font=Times New Roman;FontSize=10;FontBold=0;FontItalic=0;FontUnderline=0;TextColor=0,0,0;BackColor=255,255,204;Printable=1
I tried the following query but it doesnt return the values I want, in fact returns nothing, I am trying to create a recordset in dreamweaver, but I got no results back. I need to do the same with each and every item in the string: Fontsize, fontbold, etc.
What I need is to be able to select the value after the = sign and before the ; sign. after the name of the parameter (fontsize, etc).
I tried the following but it didnt work:
SELECT SUBSTRING(ParamName, CHARINDEX('FontItalic=', ParamName) + 11, 1) as fontitalic FROM dbo.ParametersUsers