Is it possible to order by a substring in a returned field?<BR>I've got a query which returns at most probably around 10 or so rows of 1 column. However the way this data is formated, it'd be convient ...

開始位置は 0始まりのため、1文字目は 0 指定した「開始位置＋文字数」が文字列長を超えると例外が発生する 文字数を省略する構文（Substring(開始位置)）も存在する 固定長データやコード値の切り出しでよく使用される 技術メモや学習の整理として書いて ...

This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.

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