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 & ...

SUBSTRING は、文字列の一部を抽出するための標準SQL関数です。ISO/IEC 9075（通称ISO SQL）で定義されており、多くのデータベース製品でも対応しています。 SUBSTRINGはDBによって挙動が違います。いや少し語弊があるかもしれません。SUBSTRING('abcde' FROM 3 FOR 2)のよう ...

SUBSTRING(full_name, CHARINDEX(' ', full_name) +1, LEN(full_name)) AS LastName, UPPER(LEFT(SUBSTRING(full_name, CHARINDEX(' ', full_name) +1, LEN(full_name)), 1)) AS ...

select retailer, city, product, operating_profit, sales_method, case when operating_profit = 0 then 'No Profit' when operating_profit > 0 and operating_profit < 500 then 'marginal profit' when ...