HELP! - 8060 limit/select statement

Hello all,

I want to know if it's possible to make a select statement that brings only
the records with a number of bytes of less than 8060

so, imagine I have a table with 10 records, and two of those ten records
have more than 8060 bytes, so, if I do this:

select a, b, c, d from tableX
where (len(a)+len(b)+len(c)+len(d) < 8060)

it will only bring 8 records, not 10

I tried this approach and it doesn't work, so, my question is, is there a
way (similar to this) using a select statement to limit the results to those
records with less than 8060 bytes, so I will never get the error?

Thanks again for all your help!,
SB-R

BTW, I'm using SQL Server 2000

Thanks again...


"segis bata" wrote in message

> Hello all,
>
> I want to know if it's possible to make a select statement that brings
> only the records with a number of bytes of less than 8060
>
> so, imagine I have a table with 10 records, and two of those ten records
> have more than 8060 bytes, so, if I do this:
>
> select a, b, c, d from tableX
> where (len(a)+len(b)+len(c)+len(d) < 8060)
>
> it will only bring 8 records, not 10
>
> I tried this approach and it doesn't work, so, my question is, is there a
> way (similar to this) using a select statement to limit the results to
> those records with less than 8060 bytes, so I will never get the error?
>
> Thanks again for all your help!,
> SB-R