Ache itens full editados

Assunto: Ache itens full editados Dom Mar 09, 2008 7:18 pm

Rode isso no query

**editado**

ACHAR ITENS FULL NO BAÚ

select * from warehouse where
((charindex (0xbf, items) %10= Cool

or (charindex (0xff, items) %10= Cool

or (charindex (0x7f, items) %10= Cool

or (charindex (0x37, items) %10= Cool

or (charindex (0x2f, items) %10= Cool

or (charindex (0x2e, items) %10= Cool

or (charindex (0x1f, items) %10= Cool

or (charindex (0x3b, items) %10= Cool

or (charindex (0x39, items) %10= Cool

or (charindex (0x3d, items) %10= Cool

or (charindex (0x3e, items) %10= Cool

or (charindex (0x36, items) %10= Cool

or (charindex (0x3a, items) %10= Cool

or (charindex (0x0f, items) %10= Cool

or (charindex (0x17, items) %10= Cool

or (charindex (0x27, items) %10= Cool

or (charindex (0x3f, items) %10= Cool

)

**ACHAR ITENS FULL NO INVENTÓRIO**

select * from character where ((charindex (0xbf, inventory) %10= Cool

or (charindex (0xff, inventory) %10= Cool

or (charindex (0x7f, inventory) %10= Cool

or (charindex (0x37, inventory) %10= Cool

or (charindex (0x2f, inventory) %10= Cool

or (charindex (0x2e, inventory) %10= Cool

or (charindex (0x1f, inventory) %10= Cool

or (charindex (0x3b, inventory) %10= Cool

or (charindex (0x39, inventory) %10= Cool

or (charindex (0x3d, inventory) %10= Cool

or (charindex (0x3e, inventory) %10= Cool

or (charindex (0x36, inventory) %10= Cool

or (charindex (0x3a, inventory) %10= Cool

or (charindex (0x0f, inventory) %10= Cool

or (charindex (0x17, inventory) %10= Cool

or (charindex (0x27, inventory) %10= Cool

or (charindex (0x3f, inventory) %10= Cool

)