SQL SELECT names between 2 characters in sql server table

Get names between 2 characters in sql server table

Introduction:

Just find out the names between two characters starting with characters a to d in a sql server datatable column.

Description:

      I have a name column as like below, 

Now I am going to select the names from the column whos names were starting from letter a to d.

Use 

Select * from names where name like '[a-d]%'

and this returns me the following result.

******************************************************