Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Replace non numeric characters in string

    SSC Journeyman's algorithm seems to be the fastest. Here's an enhanced version:

    ALTER FUNCTION dbo.DigitsOnly (@string VARCHAR(8000))

    /* TEST:

    Select [1]=dbo.DigitsOnly('1'), [1234]=dbo.DigitsOnly('asdf1234'), [4312]=dbo.DigitsOnly('asdf4321')

    Select Blank=dbo.DigitsOnly(''), BlankForNull=dbo.DigitsOnly(NULL), BlankForA=dbo.DigitsOnly('A')

    */

    RETURNS VARCHAR(8000) AS

    BEGIN

    declare...

    February 23, 2010 at 10:16 am

    #1123744

  • RE: Replace non numeric characters in string

    This seems the fastest. Here is an enhanced version:

    ALTER FUNCTION dbo.DigitsOnly (@string VARCHAR(8000))

    /* TEST:

    Select [1]=dbo.DigitsOnly('1'), [1234]=dbo.DigitsOnly('asdf1234'), [4312]=dbo.DigitsOnly('asdf4321')

    Select Blank=dbo.DigitsOnly(''), BlankForNull=dbo.DigitsOnly(NULL), BlankForA=dbo.DigitsOnly('A')

    */

    RETURNS VARCHAR(8000) AS

    BEGIN

    declare @pos smallint

    ...

    February 23, 2010 at 9:27 am

    #1123702

Viewing 2 posts - 1 through 2 (of 2 total)