My current table structure is :

TitleID : int
Text : varcahar(20);

and table holds data like

TitleId Text
------------- ---------------
2 20
3 45
8 90
4 30
5 60

Now my client wants to fetch those records whose text>30 and text<=50. I can not change datatype form varchar to any numeric data type.

If i use that logical condition results does not comes properly and it is very normal. Can anybody tell me how i can solve this problem without change datatype.

be careful, TEXT is a reserved word