Searching for String Length in DB

[netfrugal]

Having a hard time finding an example of a sql statement I can use to find phone numbers more than 10 characters long.

SELECT * FROM customers WHERE ...... phone length is greater than 10 characters...

anyone done this before?

[laserlight]

You could use the LENGTH function, e.g.,

SELECT * FROM customers WHERE LENGTH(phone) > 10