--- It aims to support SQL users to smartly retrieve data to support data professionals. --- Context: Databases have the data stored in an organized manner. However, we may come across situations ...

[!INCLUDE [sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw-fabricsqldb](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw-fabricsqldb.md)] Returns ...

I'm having to hack a report together to pull data from another field in the same table. The row selection is going to be based on various elements in the above 'foreignkey' field - elements 1, 2, 4 & ...

So I was handed a VERY complex script simply to turn into a pipe delimited file. The problem is that I cant seem to trim anything that used substring. for example I have tried all of these with no ...