3rd position of a field is " "

[Guest]

I need to delete accounts that the 3rd position from the left is a space.

 

[John Spencer]

To identify the records

WHERE SomeField LIKE "?? *"

or

WHERE Mid(SomeField,3,1) = " "

Field: Some Field
Criteria: LIKE "?? *"


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

DELETE tblCHARI.*
FROM tblCHARI
WHERE InStr(1,[Accounts]," ") = 3;

I'm assuming that you mean the entire record.

 

[Guest]

Run a select query to verify what you want to delete first. Maybe backup the
database just in case.
Use this for criteria --
Like "?? *"
The two question marks say that there are two characters preceding the space.