Field lenght

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all
I want to select those records that have a length of less than 2 in FiledA.
Anyone can help me?
 
Raul said:
Hello all
I want to select those records that have a length of less than 2 in
FiledA. Anyone can help me?
Click to expand...

SELECT *
FROM TableName
WHERE Len([FieldA]) < 2
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Length 3
FIlter on filed making a calulation 6
Access's 'Left' function not working properly 6
MS word Find and Replace using Regex - Help required 0
Update Query Without Replacing Text 3
How to enter formula to give warnings 2
Formula for showing warnings when cells are out of range. 1
How to import Excel to Access using VBA 2

Back
Top