Solved

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

Posted on 2013-11-10
2
321 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

816 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now