Greetings All,

I have a soc sec number that I need to remove the dashes from within a
stored procedure.

In other words take sSocSecNo where the value is 123-45-6789 and output
123456789 in SOC_SEC_NO

Is this possible using Firebird 1.5?

If so an example would be great...

Thanks,
Mike