SQL Query Help - find Field Name within Text - Iterative loop
Hi
I need some help to write an SQL query please. I have a problem in my application where using calculated fields works fine when working with database fields or constants, and is also fine when a calculated field is used within another calculated field. It break when there are nested calculated fields beyond 1 level deep. I wish to construct a SQL query to identify to me any records which this affects.
Here is a sample of some rows where the problem exists:
Open in new window