Comments by ZGelic (Top 4 by date)

In that case how many combinations of query exists? And each one should be stored as stored procedure... User can pass any two letters for (select from) and any two letters for (select to). I had in mind something like( I don't know if it is possible):
select * from table1 where SUBSTRING(table1.column2,1,2)<@param1 and SUBSTRING(table1.column2,1,2)>@param2

your querry would return only ones starting with a and t and not for all the letters in between a and t...
anyway thanks

yes but what if range is greater than from a% to b% for example from a% to t% then output should look like
aa, ab, ac, ... ba, bc, bb... ca, cb, cc..... ta, tb, tc,... tz (first two starting letters)