Hi friends,

I need to extract the initials from Emp_name which is of type char(30)

The name field may contains the values as

First-name, middle name, last-name
or
First-name, last-name
or
First-name

e.g
Name: Maria Mendoza
initial: MM

Name : Ramesh
initial : R

is that possible to write as a single query with locate & substr functions.

Thanks,
Ramesh

You can do it as a UDF.

Andy