> Hi all,
>
> I want to process strings stored procedure.
>
> Examples:
> '1' -> '0001'
> '12345' -> '54321'
>
> How can I do this?
>
> Regards
>
> Jürgen

You could write a UDF to do this - but that might be some work. Otherwise
you can do it in an SP by CAST ing your integers and playing around with the
substring or F_MID functions available in the UDF library
Alan