Search results for query: *

bump

I can't get any function to work that will return string length. I can although use the function and delete the onese that are longer or shorter than 7 delete from customer where membernum < '0000001' or membernum > '09999999999' What I'm left here is all membernum are 7 characters long. At...

sorry... select * from customer WHERE NOT (CHAR_LENGTH(membernum) = 7);

I ran select 8 from customer WHERE NOT (CHAR_LENGTH(membernum) = 7); And I get "Function Unknown CHAR_LENGTH

I'm using Borland 6.5 and SQL Explorer 3.0

Thanks for your reply, This looks interesting, although I get an SQL error: "Token Unknown - Line 2, Char 27 FROM " Any idea?

Hi, I have a customer table with ~1 million records. I have an external application that performs sertain task to the member number. It requires that the member number is exactly 7 digits long (table is alphanumeric). There is a record in that table that either has a letter or a symbol. I...