Home Forums SQL Server 7,2000 T-SQL Trimming Last 3 Numbers from some Records RE: Trimming Last 3 Numbers from some Records

  • September 1, 2014 at 3:24 am

    #1742191

    Eirikur Eiriksson (9/1/2014)

    Here is another method, find the last character which is not space or numeric

    😎

    Hi Eiriksson,

    There are also quite records like 'ABC DEF 210 ' , 'ggh / sah ggh 590'...

    So does the logic applies for these too ?

    If possible can i get any function directly for these ..to check if the last digits are numbers ..if they are numbers then delete them and also the sapce and if not Trim the last space

    Thanks & Regards,

    Guitar Player