Very useful for bypassing, magic_quotes() and similar filters, or even WAFs.

You can write hex like these:

0xHEXNUMBER
 
SELECT 0x5045 // This is not an integer it will be a string from Hex.
SELECT 0x50 + 0x45 // This is integer now!