Achar Itens Full no Char ou Bau
Galera segue essa query para procurar itens full no bau ou no char, eu usei muito na 97d, não testei em outras versões
ACHAR ITENS FULL NO BAÚ
Citação:
select * from warehouse where
((charindex (0xbf, items) %10=8)
or (charindex (0xff, items) %10=8)
or (charindex (0x7f, items) %10=8)
or (charindex (0x37, items) %10=8)
or (charindex (0x2f, items) %10=8)
or (charindex (0x2e, items) %10=8)
or (charindex (0x1f, items) %10=8)
or (charindex (0x3b, items) %10=8)
or (charindex (0x39, items) %10=8)
or (charindex (0x3d, items) %10=8)
or (charindex (0x3e, items) %10=8)
or (charindex (0x36, items) %10=8)
or (charindex (0x3a, items) %10=8)
or (charindex (0x0f, items) %10=8)
or (charindex (0x17, items) %10=8)
or (charindex (0x27, items) %10=8)
or (charindex (0x3f, items) %10=8))
**ACHAR ITENS FULL NO INVENTÓRIO**
Citação:
select * from character where ((charindex (0xbf, inventory) %10=8)
or (charindex (0xff, inventory) %10=8)
or (charindex (0x7f, inventory) %10=8)
or (charindex (0x37, inventory) %10=8)
or (charindex (0x2f, inventory) %10=8)
or (charindex (0x2e, inventory) %10=8)
or (charindex (0x1f, inventory) %10=8)
or (charindex (0x3b, inventory) %10=8)
or (charindex (0x39, inventory) %10=8)
or (charindex (0x3d, inventory) %10=8)
or (charindex (0x3e, inventory) %10=8)
or (charindex (0x36, inventory) %10=8)
or (charindex (0x3a, inventory) %10=8)
or (charindex (0x0f, inventory) %10=8)
or (charindex (0x17, inventory) %10=8)
or (charindex (0x27, inventory) %10=8)
or (charindex (0x3f, inventory) %10=8))
By Kr0nuS
