Split data alphabetic

[gorgin]

Hi all,

I wonder if someone could help me. how can I list information based on their beginning letter?

for example I have a list of names as: Jack, Christian, Ferdinand, Tom, George, Sofia, Al.

I want to list the people whose names begin by a letter between A-M.

is there any instruction in SQL that can help me to split the list of data like that?

I thank you in advance.

 

[rtmpxr]

select distinct name from <your table> where name between 'A' and 'N' order by name