>Hello everybody
>
>I have a excell file "einzerteileraus"
>Column h contains x,X or blank
>I need all records with x or X
>
>SELECT 0
>IMPORT from einzerteileraus TYPE xls
>SELECT einzerteileraus
>
>SELECT A as idtnr,H as deletetag FROM einzerteileraus WHERE alltrim(UPPER(H)) = "X" INTO CURSOR einzerweg
>browse
>
>I have all rows of the execell file in my cursor (even if column h is " ") ???
>
>SELECT A as idtnr,H as deletetag FROM einzerteileraus WHERE UPPER(H) = "X" INTO CURSOR einzerweg
>browse
>This one works !!???
>What is the problem with alltrim() ???
>What do i miss ???
You miss the basic, namely that comparison with = always start from the left, and stops when the string on the right side of = stops. So 'X'='' but ''#'X'. In your first Select, use == instead of =. Read more in help on SET EXACT, and "String and Value Comparison in Visual FoxPro"
>Any help welcomed
>Best regards
>Albert