SQL Group By single character

SELECT LEFT(pcode, 2) AS pcode2 FROM addy GROUP BY pcode2

Removing an empty div using Jquery

$('.selector:empty').remove();

Another Way

$.expr[':'].blank = function(obj){ return obj.innerHTML.trim().length === 0; }; $('.selector:empty').remove();