where name >= 'AA%' and name <= 'MZ%'
might do the trick, but make sure you check the edge cases.
On Wed, Aug 8, 2018 at 4:07 PM Rafael Copquin rafael.copquin@gmail.com wrote:
I have a SQL Server table with client names. I need to select a range of names from this list, but the between clause does not work well
Example; select all names begininng with A up to M
sql statement
select name from mydatabase.dbo.customers where name between 'A%' and 'M%' order by name
The result is a list of names beginning with A and up to L
To get the names beginning with M I need to write the where clause as follows
where name between 'A%' and 'N%'
I also tried :
where name >= 'A%' and name <= 'M%'
The resultant list goes from A to L, it does not show the names beginning with 'M'
What is the solution, please?
BTW, is there a range function in T-SQL, similar to Excel (A:M)?
Rafael Copquin
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---