find values of a certain length

I was wondering if there was a way to do a querry in sql where you only want to show results where a specific column has a character length of 5.

Is it possible?
LVL 1
gfedzAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Ephraim WangoyaConnect With a Mentor Commented:
select * from table1
where LEN(Fieldname) = 5
0
 
gfedzAuthor Commented:
Perfect, thank you for your time!
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.

All Courses

From novice to tech pro — start learning today.