Need Help Shortening WHERE Clause Currently over 255 Characters

[dreamaz]

Hi

I posted this in the MS SQL forum but just found out we are using Sybase 12.5.

Problem is, my current select statement exceeds 255 characters...and only the first 255 are being considered thus making the statement useless. Any suggestions?

select record_id from editorial_sub8 where a1 like'%|He%' or a1 like'%|Ent B%' or a1 like'%|Fin B%' or a1 like'%|Music B%' or a1 like'%|News B%' or a1 like'%|Sports B%' or a1 like'%|Travel B%' or a1 like'%|Weather B%' or a1 like'%|Welcome B%'

Thanks folks

 

[dreamaz]

Sorry folks,

jsut did a char-count and that adds up to 242... so i'm assuming it's already truncated.. nevertheless, any suggestions on how to shorten the statement and still include all the clauses?

 

[DiscoStuart]

Hi,

Why not use the UNION clause to split your query into two or more select statements.

e.g.

select record_id from editorial_sub8 where a1 like'%|He%' or a1 like'%|Ent B%' or a1 like'%|Fin B%' or a1 like'%|Music B%' or a1 like'%|News B%'

union all

select record_id from editorial_sub8 where a1 like'%|Sports B%' or a1 like'%|Travel B%' or a1 like'%|Weather B%' or a1 like'%|Welcome B%';

hopes this helps.