Incorrect syntax near 'see'.

SELECT l_itemID, l_typeID, l_levelID, l_parentID, tx_itemName FROM d_404FriendlyNames WHERE tx_404Label = 'news/2747-dla-piper-lawyers-'see-record-promotions'';