SQL Converting a text field to other text
Absolute beginner at SQL so apologies for (hopefuly) simple question. 

I have a text field in a table that is populated by a trigger. This information is then processed and posted into a program, however the text is not valid for the program and needs to be converted into a valid text value.

Example
The value inputted into the field can either be 'Sterling' or 'EUROS' but this needs to be converted into 'GBP' (if the value is 'Sterling') or 'EUR' (if the value is 'EUROS') before it attempts to post to program.

How do I do this? 

Thanks

John
SQL Converting a text field to other text
===

Absolute beginner at SQL so apologies for (hopefuly) simple question. 

I have a text field in a table that is populated by a trigger. This information is then processed and posted into a program, however the text is not valid for the program and needs to be converted into a valid text value.

Example
The value inputted into the field can either be 'Sterling' or 'EUROS' but this needs to be converted into 'GBP' (if the value is 'Sterling') or 'EUR' (if the value is 'EUROS') before it attempts to post to program.

How do I do this? 

Thanks

John