Thread: Help with Partial string Search
View Single Post
  #4 (permalink)  
Old 12-04-2008, 6:04 PM
MattP MattP is offline
VB.NET Forum Idol
.NET Framework: .NET 2.0 (VS 2005)
  
Join Date: Feb 2008
Location: USA
Posts: 877
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
Jet should recognize SUBSTRING.

Code:
UPDATE id
SET id.NARC = aop5.sn
FROM IDENTIFICATION_DATA id, aop5 ao
WHERE SUBSTRING(ao.NSN, 6, 11) = id.NIIN
Reply With Quote