Solved

Making a query to return a field with a certain length (5 characters)

Posted on 2013-11-10
2
332 Views
Last Modified: 2013-11-10
How do I make a query to resturn only those fields that are longer than 5 characters?
0
Comment
Question by:daisypetals313
2 Comments
 
LVL 24

Accepted Solution

by:
chaau earned 500 total points
ID: 39637812
You need to use LEN() function. For example:
SELECT * FROM Table1 WHERE LEN(TextColumn)>5

Open in new window

0
 

Author Closing Comment

by:daisypetals313
ID: 39637842
Thanks much!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question