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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SUBSTR

Status
Not open for further replies.
Ruvera

Ruvera

Programmer
May 8, 2002
12
RU
There is in MS Access SQL function SUBSTR?

SELECT SUBSTR(381, 2, 10) AS G_381, G382, COUNT(G382) AS CNT
FROM TBL
WHERE G382 IS NOT NULL AND G381 IS NOT NULL AND LENGTH(G381) >= 10
GROUP BY SUBSTR(G381, 2, 10), G382
 
Sort by date Sort by votes
Ruvera,

try the MID function. Syntax:
Code: 
Mid(string, start[, length])

HTH

Cheers
Nikki
 
Upvote 0 Downvote
Thank you very much for your help!

May be you know there is in MS Access SQL function LENGTH(STRING)?
 
Upvote 0 Downvote
Sure, Ruvera - use
Code: 
LEN(String)

All functions are documented in Acees' Help file, btw - that might get you quicker results

HTH

Cheers
Nikki
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Cineno
  • Locked
  • Question
Finding a report from a substring
Replies
2
Views
66
Cineno
Cineno
mauricionava
  • Locked
  • Question
Add or Substract with command buttons
Replies
1
Views
50
Crowley16
Crowley16
patyavila
  • Locked
  • Question
Look for a substring
Replies
1
Views
55
PHV
PHV
chrislx
  • Locked
  • Question
Substring Replace 2
Replies
2
Views
71
PHV
PHV
judvos
  • Locked
  • Question
substract stock items from my oldest date
Replies
15
Views
187
docmeizie
docmeizie

Part and Inventory Search

Sponsor

Back
Top