Match the String in a join

• komal145

  SSCrazy Eights

  Points: 9915

  More actions

  April 10, 2024 at 3:48 pm

  #4409735

  i have Two tables T1 , T2

  Create table T1( Activity varchar (100))

  Create Table T2 ( Activity varchar (100))

  T1 table has data as below

  Activity (field)

  SendToUser% (data)

  T2 table data

  Activity (field)

  SendToUser-U12345

  So , both tables should match ...because the string SendToUser% means  "SendToUser"+"....."

  How can i use it in join?

  Select * from T1 Join T2 on left(T1.activity, len(T1.activity)-1)  like Concat('%',T2.activity,'%')

  The above query is not working 🙁

   

   

   

   

• pietlinden

  SSC Guru

  Points: 63434

  More actions

  April 10, 2024 at 4:22 pm

  #4409740

  You have that many points and you can't be bothered to post some consumable data?

  You could join on

  LEFT(TableA[column],8) = LEFT(TableB[column],8)

  • This reply was modified 3 weeks ago by  pietlinden.

• Ed B

  Hall of Fame

  Points: 3620

  More actions

  April 10, 2024 at 6:56 pm

  #4409806

  Try this

  Select * from T1 
  Join T2  on T2.activity LIKE CONCAT('%',left(T1.activity, len(T1.activity)-1),'%')