Thread: Help with Partial string Search
View Single Post
  #2 (permalink)  
Old 12-04-2008, 5:04 PM
MattP MattP is offline
VB.NET Forum Idol
.NET Framework: .NET 2.0 (VS 2005)
  
Join Date: Feb 2008
Location: USA
Posts: 866
Reputation: 499
MattP has a reputation beyond reputeMattP has a reputation beyond reputeMattP has a reputation beyond reputeMattP has a reputation beyond reputeMattP has a reputation beyond reputeMattP has a reputation beyond reputeMattP has a reputation beyond reputeMattP has a reputation beyond reputeMattP has a reputation beyond reputeMattP has a reputation beyond reputeMattP has a reputation beyond repute
Default
Didn't I answer this one already?

Code:
SELECT *
FROM TableA a JOIN TableB b ON SUBSTRING(a.column, 5, 11) = b.column
Reply With Quote