|
-
September 2nd, 2003, 10:45 AM
#1
TSQL return value out of range
Declare @fromitem varchar(15), @toitem varchar(15)
set @fromitem=10
set @toitem=60
select categoryid,categoryno ,@fromitem , @toitem from category
where categoryno>=10 and categoryno<=60
thes must return categoryno between 10 and 60
but it return 1 and 2 and 3 and........
Why?
Categoryno varchar(15) becuase there is many items contains letters.
Help Please
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
|