Thanks for your help, but you are right this isn’t going to scale, I have several other values I need to compare in the same WHERE clause all using similar comma separated ids. If I normalised the database would this allow the query to scale?
In other words, just the kind of things I’ve been trying to do.
Its a pig really, I’d have never designed this database this way. The developer who had this before me obviously saw the merits of just taking a comma separated list of field values and dumping them into the insert and update routine writing the Property Requirements values into a single table. But now I’m been asked to do something useful with this data its proving a proper pain in the butt.