By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,917 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Substrg command in Access

P: 4
I am using Access 2000.
I need Substrg command in Access 2000.
Kindly send the SQL script for the same in Access 2000.
Feb 26 '07 #1
Share this Question
Share on Google+
4 Replies


dorinbogdan
Expert 100+
P: 839
Use the Mid function.
Feb 26 '07 #2

P: 4
Thanks for your reply.
kindly teach me how to use mid function in Access SQL editor
Feb 28 '07 #3

P: 4
Thankyou.
Kindly teach me how to use mid function in access SQL editor
Feb 28 '07 #4

dorinbogdan
Expert 100+
P: 839
Expand|Select|Wrap|Line Numbers
  1. ' Creates text string.
  2. Dim TestString As String 
  3. TestString = "Mid Function Demo"
  4. ' Returns "Mid".
  5. Dim FirstWord As String 
  6. FirstWord = Mid(TestString, 1, 3)
  7. ' Returns "Demo".
  8. Dim LastWord As String 
  9. LastWord = Mid(TestString, 14, 4)
  10. ' Returns "Function Demo".
  11. Dim MidWords As String 
  12. MidWords = Mid(TestString, 5)
  13.  
  14.  
  15.  
Feb 28 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.