Query on partial field

[PB90]

I would like to create a query based on the 3rd & 4th characters in a field. The total field is 8 characters.

ex. find all records where those characters are "FR"

field name is trkNum.

Any ideas?

 

[LittleSmudge]

How about:-

SELECT * FROM tblName WHERE Mid([trkNum], 3, 2) = 'FR'


'ope-that-'elps.




G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[PHV]

Another way:
WHERE trkNum Like '??FR*'

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886