string length

[tuzojazz]

Hi:suppose I have this tableCUSTOMERS---------------------Name---------------------JohnGabrielGeorgeKenI need to make a query to get customers where the Name length is equal or greater than 6Name--------------------GabrielGeorgeHow Can I make this query or/and where can I find information about this kind of query?Thanks!!

[reportingsjr]

<?php$query = "SELECT * FROM `customers`";$result = mysql_query($result);while($row =mysql_num_rows($result){   if(strlen($row[0]) > 6){	  //do whatever, like echo the name or do what you want   }}?>

Hopefully this will help you

[skym]

SELECT * FROM 'customers' WHERE CHAR_LENGTH(Name)>=6http://dev.mysql.com/doc/refman/4.1/en/string-functions.html

[tuzojazz]

Hi:Thanks but char_length does not work in access.Is there a function that works in access?

[aspnetguy]

use Len() in MS Access and SQL Server