Home Forums SQL Server 2005 T-SQL (SS2K5) allow varchar value to string and decimal parts RE: allow varchar value to string and decimal parts

  • August 29, 2008 at 5:34 am

    #864936

    Hi,

    try the below one.

    DECLARE @Text VARCHAR(16)

    SET @Text = 'ABC222'

    SELECT SUBSTRING(@Text,PATINDEX('%[0-9]%',@Text),LEN(@Text)) + 100

    ---