I am rather new to WebFocus, and I am sure there is a easy way to do this, but I am having a problem figuring this out. I only want to report a field when the second character in the field equals the letter "B".

My thought would be to create a define statemnet that reports the second letter of the field - but can't figure out how to get the define statement to only report the second position. Then I figure in my where clause I would just select the define statement when it equals B.

Thanks for your help.

This message has been edited. Last edited by: Kerry,

You can use the EDIT MASK feature:

DEFINE FILE CAR
COUNTRY2/A1=EDIT(COUNTRY,'$9');
END
TABLE FILE CAR
PRINT 
SALES
BY COUNTRY
WHERE COUNTRY2 EQ 'N'
END

Wow - that was easy. I thought Edit could only be used with Compute. Thank You!

Roxanna,

Paraphrasing Cyrano de Bergerac, here are a few variations:

If you are already using the WHERE command (as opposed to IF) you can do away with the DEFINE and write:

  
TABLE FILE CAR
PRINT 
SALES
BY COUNTRY
WHERE EDIT(COUNTRY,'$9') EQ 'N'
END

You can also use a mask in the WHERE command:

  
TABLE FILE CAR
PRINT 
SALES
BY COUNTRY
WHERE COUNTRY LIKE '_N%'
END

or, with the good old IF

  
TABLE FILE CAR
PRINT 
SALES
BY COUNTRY
IF COUNTRY EQ '$N$*'
END

Cyrano writing to Roxanna.
My God, this Forum is not for geeks only.
So many thanks, my day is enlightenned
F and C
PS : "C'était donc vous" from Roxanna to Dying Cyrano is admirable.

yes, but before that:
"et le samedi 26, une heure avant diner
monsieur de bergerac est mort, assassine"

[sorry no acents on my english keyboard]