get first 20 character of a string
Hi guys,
i have a table with name employee
and fields first_name, last_name.
I want to get first 20 characters by concatinating the first_name and last_name.
how can i do this using an sql command.
like if the name is Mirza Imran Baig Ahmed Khan as stored in the database by concatinating first name and last name.
i want to get result like this
Mirza Imran Baig Ahmed.
How can i use ltim or rtim while concatinating the name. pliz help
Imran Baig