Re: SQL queries from weird data

[RichardK]

in reply to SQL queries from weird data

To me, the problem looks more like an issue with your database schema design.

If you normalised out the "other" column into its own key/value table then your problem would go away and your code would be nice and simple :)

[Neighbour]

Indeed. And you wouldn't be trying to execute data, which is something to be avoided.

[Anonymous Monk]

I should have been more clear, this isn't our schema, these aren't our tables. This is generated by a third party product (VB.Net front end, Oracle back end) over which we have zero control. We're trying to provide more functionality via some scripting. We want to do things this product doesn't do.