Filter on N digits

[NickK]

Hello, 

I have a numeric variable that is 6 numbers in length. I'd like to use SQL to only keep the numbers that are 3 digits long. So, for example, I would keep 123 but not 1234 or 12345 or 123456. 

Thanks. 

[PaigeMiller · Accepted solution]

In SQL, have it filter for any value between 100 and 999.

[NickK]

So now the question is if the variable is character, how do I filter on that?

[ballardw]

---

@NickK wrote:

So now the question is if the variable is character, how do I filter on that?

---

where length(variablename) =3

unless you have leading spaces in your character variable, then you need to STRIP the variable to remove leading spaces if you do not want to count them.

[PaigeMiller]

Do you consider a character string of 003 to be 3 digits or 1 digit?

[NickK]

There's no leading 0s or blanks in this case.