Posts by lcoelho • 1 point

• 0

  votes

  2

  answers

  75

  views

  A: Filter data table

  Thanks for the tips Solved the problem DECLARE @teste varchar(100) SET @teste = '"brt_qsr01:NT"' select SUBSTRING(@teste,CHARINDEX('_',@teste)+1,CHARINDEX(':',@teste)-CHARINDEX('_',@teste)-1)…

  sql-server

  answered 6 years, 8 months ago lcoelho 1

• 0

  votes

  2

  answers

  75

  views

  Q: Filter data table

  How to select only part of a table record? Source data: "brt_qsr01:NT" and I intended it to return only qsr01 I’m doing so, but then I can’t remove the data on the left SELECT left([coluna],…

  sql-server

  asked 6 years, 8 months ago lcoelho 1