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! */