/* Eggy Peggy Language is a secret language rather like Pig Latin or Cockney Rhyming slang. It takes a while to master, but was once used, in particular, by schoolgirls to talk privately when there was a chance of being overheard by outsiders, and it could be spoken and understood very rapidly, but was unintelligible to the untrained ear.

In essence, the string 'egg' is inserted before every vowel.

There are dialects of Eggy Peggy language and the same sort of idea is used in Pig Latin, Jeringozo, Verlan, and Ubbi Dubbi.

Here is a simple translator into Eggy Peggy language, using a device which came to me almost by accident.

You will realise, of course that the system can be used for all sorts of serious programming applications, including macro processing.

I've kept things simple just to show the principle, but of course I've ignored the problems of processing words with capital letters. We'd also need a back-translator or decoder. I'd be interested to see these.

What about a Pig Latin Translator? */

DECLARE @SampleParagraph VARCHAR(8000)

SELECT @SampleParagraph='"One must clearly state that the 

assessment of any significant weaknesses in the central 

monologism cannot be shown to be relevant. This has to be

considered in contrast to the apprehension of the 

deterministic aspect

"Dean Carson in 

The Journal Of The Collaborative Integrated Transposition 

(1997)

'

DECLARE @EggyPeggy TABLE (vowel CHAR(1),replacement VARCHAR(4))
INSERT INTO @EggyPeggy (vowel,Replacement) SELECT 'e', 'egge'

INSERT INTO @EggyPeggy (vowel,Replacement) SELECT 'a', 'egga'

INSERT INTO @EggyPeggy (vowel,Replacement) SELECT 'i', 'eggi'

INSERT INTO @EggyPeggy (vowel,Replacement) SELECT 'o', 'eggo'

INSERT INTO @EggyPeggy (vowel,Replacement) SELECT 'u', 'eggu'





SELECT @SampleParagraph=REPLACE

                       (@SampleParagraph,vowel,replacement) 

       FROM @EggyPeggy 

       WHERE CHARINDEX(vowel,@SampleParagraph)>0

SELECT @SampleParagraph