RE: Display numeric string of the form 01W or 02Y

> The string that I am trying to display is an entry in the 
> database 'Tenor'. Its format is like 1W or 2W or 1Y.
> But, when I have to output it, it should be in the form 01W 
> or 02W or 03W or 01Y or 10Y with a zero appended in the 
> beginning. The number format cannot be used here.

Try:

replace($in, '^([0-9][A-Z])$', '0$1')

Regards,

Michael Kay
http://www.saxonica.com/
http://twitter.com/michaelhkay