dkim18
asked on
Match ((XXX)) in sql?
Hi,
I am trying to grab ((xxxx)) part out of this field.
This field contains ((xxx*))xxxxx.
x varies in length.
How can I parse it out in sql?
Thanks.
I am trying to grab ((xxxx)) part out of this field.
This field contains ((xxx*))xxxxx.
x varies in length.
How can I parse it out in sql?
Thanks.
Can you give a better example? Maybe some sample data and the data types?
ASKER
it is nvarchar(255).
((xxxxxssdsdsd)), dfdfdfdfdffdffdf dfdfd
((xererdsdsd)) dfdfdffdffdf,dfdfd
((xxssdsdsd)), dfdfdfdfdxxffdffdf dfdf
((xererdsdsd)) dfdfcdffdffdf dfdf
((xsdsdsd)), dfdfdfdfdffdffdf dfdf
((xererdsdsd)) dfdfcdffdffdf fdfdf
((xxxssdsdsd)), dfdfddfdfdffdffdf fdfdf
((xrdsdsd)) dfdfdffedffdf
((xxxssdsdsd)), dfdffdffdffdf vdfdf
((xerdsdsd)) dfddffdf
((xxxssdsdsd)), dfdfdfdfdffdf xxx
((xerdsdsd)) dfdfdffdffdf
((xxxxxssdsdsd)), dfdfdfdfdffdffdf dfdfd
((xererdsdsd)) dfdfdffdffdf,dfdfd
((xxssdsdsd)), dfdfdfdfdxxffdffdf dfdf
((xererdsdsd)) dfdfcdffdffdf dfdf
((xsdsdsd)), dfdfdfdfdffdffdf dfdf
((xererdsdsd)) dfdfcdffdffdf fdfdf
((xxxssdsdsd)), dfdfddfdfdffdffdf fdfdf
((xrdsdsd)) dfdfdffedffdf
((xxxssdsdsd)), dfdffdffdffdf vdfdf
((xerdsdsd)) dfddffdf
((xxxssdsdsd)), dfdfdfdfdffdf xxx
((xerdsdsd)) dfdfdffdffdf
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.