| Subject | What does SUBSTRING return? |
|---|---|
| Author | Bjoern Reimer |
| Post date | 2004-09-08T13:19:46Z |
Hi,
Helen's book doesn't answer all questions :-)
What does substring (Internal function) return?
e.g.
SELECT '#'||substring('ABC' FROM 1 FOR 10)||'#' FROM rdb$database;
returns #ABC#
but in a stored procedure where ABC is a varchar variable it returns
#ABC #
(There is no char field in the sp. Of course ABC is a value from a
variable which is a param of the proc...)
Why?
Björn
--
Björn Reimer -- RRZE
Tel: +49-9131 - 85-27809
Fax: +49-9131 - 302941
Martensstr. 1 / 2.021
D - 9 1 0 5 8 Erlangen
www.rrze.uni-erlangen.de
Helen's book doesn't answer all questions :-)
What does substring (Internal function) return?
e.g.
SELECT '#'||substring('ABC' FROM 1 FOR 10)||'#' FROM rdb$database;
returns #ABC#
but in a stored procedure where ABC is a varchar variable it returns
#ABC #
(There is no char field in the sp. Of course ABC is a value from a
variable which is a param of the proc...)
Why?
Björn
--
Björn Reimer -- RRZE
Tel: +49-9131 - 85-27809
Fax: +49-9131 - 302941
Martensstr. 1 / 2.021
D - 9 1 0 5 8 Erlangen
www.rrze.uni-erlangen.de