Select range in SQL

I have a sql database that have InvoiceNumber column

Now i need to select range between two numbers, but i don’t know what happened.

I’ve tried “Between” and “<= , >=” Statements but the results are same.

Table

My query

For example: If i need range between “13000” and “13020” and there is number “1301” its appear in results.

Answer

You will need to conver your value in the where clause to do this.