DB2 SQL problem. . . 1. B. Table A certain fields, many of the "LC" at the beginning of the record, but I went to select count (*) from A where ucase (ltrim (B)) like 'LC-%' always only one record, do not know why? 2. Table another customer, a customer name field is that the importation of "good" word inquiries names, and the results of many names simply failed to "good" characters from the record, but the importation of "Lee" to make inquiries as to when the inquiries, says that the name "Lee." This is the Web interface using SQL is the case, why? DB2 SQL problem. . . Nobody encountered? Analysis of what might help, thank you! DB2 SQL problem. . . 1, you count (*) is only one course 2, and table structure released sgl record DB2 SQL problem. . . 1. I am not saying that the outcome itself, but count the number. Use select count (*) from A where ucase (ltrim (B)) like 'LC-%' results 1 ------------ 1 1 record (s) selected. Of the records should have more than 1,000. 2. This table is a customer information table, a customer ID, name, EMAIL, telephone, contact address whatever. Oprs, you need to complete the form and structure of some records? Also, what is grateful oprs and experts in the field when the results of inquiries db2cmd window Lane topological structure will be divided into many more long trip, I feel very chaotic, there is no oracle can be defined as the width of the output function out? DB2 SQL problem. . . --> 1, the B field with your box? The change of SQL : [code]select Count (*) from A where ucase (rtrim (ltrim (B))) like 'LC-%' [/code] 2, Chinese characters used LIKE is bad, a Chinese word after the word before and after the Chinese characters form a new word, unless your conditions are relatively accurate. Or take a look at SQL! For example, many functions can be adjusted format substr DB2 SQL problem. . . --> 1. * You select. . . . Is one or more of the record? 2. Is ah, this should kk specific content, such sgl, those records DB2 SQL problem. . . I used to select * encountered. . . . Many of the select count (*). . . . The result is one of the issues very interesting DB2 SQL problem. . . 1. If Sectional Drawing, we can see that not only the front of a record box, the box has other, but with ltrim () Why is no way to do with the future? Like ucase (ltrim (rtrim (A))), the result is incorrect] 2.SQL select name from cu_customer is where name like '%% good'. 3. Substr son used to get string, and even record the interception of the contents of a field, do not know all the records of the number of hours is the maximum length of the field as, well defined parameters. Not only determine the width shows, not as a function of the interception? Please enlighten me, thank you! DB2 SQL problem. . . --> 1. This view, it should select * is the only one, and I think we have is not the same thing :) Another record before those ballots should not only are there other characters b 2. Who found out without the 'good' kind of record how? Stickers point out kk 3. Look at the record you want convenience, I think they are still using some tools more generous Client DB2 SQL problem. . . --> Not even determine the length? Want to know the maximum length? Otherwise, how to deal with test questions : [code]varchar (Rtrim (ltrim (product_code)), 16) [/code] DB2 SQL problem. . . Thanks to the support of two withheld. 1. TAB which is used to trim away, I did not replace now beyond question. 2. Mymm this issue is the reason it seems so, like Chinese characters used wildcard match did this problem. I do not know if I have any solutions? 3. Sectional Drawing to see if the field more and not do anything, the results will show very chaotic, it is difficult to see what response is a record field. Mymm some of the methods used, Oracle similar to the PGA. . . . . . Format, it seems that only this kind of show. DB2 SQL problem. . . --> TAB field, there are not too good! No control over your AP? DB2 SQL problem. . . The table's data is sorted out with a large amount of SQL Excel save text documents into operation again, the time may not completely replace, some have TAB.mymm you say that the AP is what does this mean? [ Closed window ]