Home Forums Microsoft Access Microsoft Access Instr convert from access to sql server RE: Instr convert from access to sql server
DPhillips-731960
Hall of Fame
Points: 3904
More actions
March 6, 2009 at 1:10 pm
#955222
andrewd.smith (3/6/2009)...A translation of this Access expression is:LEN(SUBSTRING([Field3], 1, CHARINDEX(' or', [Field3]) - 1))
andrewd.smith (3/6/2009)
A translation of this Access expression is:
LEN(SUBSTRING([Field3], 1, CHARINDEX(' or', [Field3]) - 1))
Or simply:
CHARINDEX(' or', [Field3]) - 1