On Sat, 2003-08-30 at 14:35, mbellisle_retire wrote:

> Hello everyone
>
> How do I return a partial field value in sql in InterBase?
>
> if returns the first 5 characters, starting from the beginning of
> the value, how do I do the same with InterBase?

SELECT SUBSTRING(MY_COLUMN FROM 1 FOR 5) AS MY_COLUMN FROM MY_TABLE;

Is that what you were looking for?

--
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios, Inc.
http://www.obsidian-studios.com