Hi Tore,
sorry for my wrong moves, anyway i forgot to set exact on.
thanks for all the tips and guidance.

God Bless All,
Ryan.

Hi Ryan,

PLease don't make a new thread unless it is a NEW thread! You have already got many tips, which are very good in deed.

1. Drop the ALLTRIM, it is not optimizable. Unless you have an index on ALLTRIM, which you must not use unless you love to take risks!!!!!
2. replace the == with = and set exact on in stead

Remember you must have an index on the clause before = in the the where statements.