Query by number of characrers in a data column?

[octavian10]

Hello, is there a way to query a sql database by the amount of characters? I am trying to find account numbers longer than 12 characters. Thanks

"I hear and I forget. I see and I remember. I do and I understand."
- Confucius (551 BC - 479)

 

[SgtJarrow]

Did you try:

SELECT
    column(s)
FROM table
WHERE LEN(somecolumn) > 12

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
C#.NET Programmer

 

[octavian10]

No but that worked! Thanks so much

"I hear and I forget. I see and I remember. I do and I understand."
- Confucius (551 BC - 479)