SQL question for -- substr

Hi,

I want to get the last 3 characters of a string. How can I get it?

Thanks!

substr(length('ABCDEFG')-2,3), i would think.

Thanks, i got it.

Even more simple and straightforward:

substr('ABCDEFG',-3)

Quote:

---

Originally posted by jmodic
Even more simple and straightforward:

substr('ABCDEFG',-3)

---

Oooooooooo!

You see if I read the documentation more often, I'd have known that.

Hi slimdave,
You've got to give it to Jurij, he's good. But don't let him know I said that, he might get big headed ;)