1
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

【SQL】SUBSTR

Last updated at Posted at 2020-06-24

★SUBSTR(文字列,文字開始位置,文字長)
・引数を対象に指定の文字数をキャラクタ単位で取り出せる

★SUBSTRB(文字列,文字開始位置,文字長)
・引数を対象に指定の文字数をバイト単位で取り出せる

文字開始位置の指定で0を指定した場合1と同様の処理となる。
指定が整数の場合は文字先頭からの数える。
指定が負数の場合は文字末尾からの数える。

1
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
1
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?