• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 369
  • Last Modified:

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

How do I make a query to resturn only those fields that are longer than 5 characters?
0
daisypetals313
Asked:
daisypetals313
1 Solution
 
chaauCommented:
You need to use LEN() function. For example:
SELECT * FROM Table1 WHERE LEN(TextColumn)>5

Open in new window

0
 
daisypetals313Author Commented:
Thanks much!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now