Get Left characters from a field

Giganews Newsgroups
Subject: Get Left characters from a field
Posted by:  Tony B (anthonybrou…@googlemail.com)
Date: 8 Nov 2006

Hi All

I am a newbie to oracle so please be kind!

I have a table with a field "Name" VarChar(20).

How do I create a view that contains a field "ShortName" (10) that
contains the first 10 characters from the "Name" field.

Thanks for your help

Tony

Replies