Tutorial 13 : SQL TRIM(), LTRIM() and RTRIM()

Hi Friends!
Here we are learning about TRIM(), LTRIM() and RTRIM() function. Hope you'll understand about these functions. Let me know for any confusion or doubt. You can write me in comment box or can mail me.

Useful Tutorial Links :

1. SQL SINGLE ROW FUNCTION EXPLAINED

2. SQL LENGTH() FUNCTION

-- Length() Function Part-1

-- Length() Function Part-2

Thanks!

[chandanpatra]

Kindly tell me 'query to remove 1st and last character of employee names'?
For example: ename is SMITH my output should be MIT.