Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Equivalent of Oracle's SUBSTR in ACCESS 1

Status
Not open for further replies.
rhino747a

rhino747a

MIS
Apr 25, 2005
7
ZA
Hi Guys,

Do any of you know the equivalent commands to Oracles SUBSTR and INSTR in Access.

Regards

Dave
 
Sort by date Sort by votes
Not knowing Oracle, I'd still guess the Access equivalence of substr, is the mid function (check it out in the help files). You can also use the Right and Left functions.

There is a InStr function in Access too.

Roy-Vidar
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Question
Select X of each variation of a field 1
Replies
8
Views
367
rashmibala
R
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
4K
lameid
lameid
serino
  • Locked
  • Question
Find a number between two sets of numbers. 1
Replies
2
Views
1K
serino
serino
combo
  • Locked
  • Question
SQL data types in CREATE/ALTER TABLE queries 1
Replies
2
Views
1K
combo
combo
C
  • Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
208
OzFoxy
OzFoxy

Part and Inventory Search

Sponsor

Back
Top