|
-
February 19th, 2005, 08:27 AM
#4
Re: select range between letters
hay all
i will give example for data
values
1
2
3
4
10
11
12
ap-512
acd-42f
sfv2-s
a9-632
.
.
etc
suppose i want only records from 10 to a9-632
it must give
10,11,12,a9-632 only
all fields is nvarchar type
i try using sum ascii of value and save its value in field and when i want retrive any data i use sum ascii for number like
12 ascii = 49+48=99 and so on
but the problem that ascii sum value of 12 is same 21 and that not solve the problem
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|