selecting left x characters from a field?

Is there an equivalant LEFT or RIGHT function from VB that works in Oracle?

Key

---
12345

Is there a way to select the first 3 characters?

SELECT LTRIM(Key,3) ....   doesn't do the trick.


thanks - medfly



Sent via Deja.com http://www.deja.com/
Before you buy.