Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2013-11-10
2
Medium Priority
?
366 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 25

Accepted Solution

by:
chaau earned 2000 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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
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…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

578 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