Posts by BrunoLima • 11 points

• 1

  votes

  2

  answers

  5887

  views

  A: Removing part of a string - SQL Server

  I’ve made an example that covers a lot of cases. Example: .txt file, .secreto.txt file, .jpeg file. Declare @campo varchar(100) = 'Arquivo.txt' select left(@campo,len(@campo) -…

  sql

  answered 7 years, 6 months ago BrunoLima 11